GEOMAPS in SAP BO mobile not working

[Former Member]

Hi Experts,

I am just trying to demonstrate the features available in BO mobile (ipad).

I am trying to use the GEOMAP feature in IPAD, but i couldnt' get the geomap structure in IPAD.

Environment: BI4.0  SP02 FP15

I followed the steps in BO_mobile guide. Here are my steps to reproduce and let me know where i need to correct.

1. Created table in database (sqlserver) with below fields and datatype.

nameoffiled     datatype

id                     integer

poi_name          varchar(20)

lat                    float

long                  float

city_name          varchar(30)

prem_amount     integer

2. Then i have inserted sample data like below

insert into table values(1,'LOS ANGELES',34.05,118.24,'LOS ANGELES',32000)

3. Created universe on top this table and made prem_amount as measure object. (all other objects are dimensions)

4. Created webi report with simple vertical table using all above objects in same order.

5. Right click on table>>table format>> Changed the name to ";map_lt(3),lo(4)_poi(2)"

(i didnt' use od and imu parameters  as these are optional).

6. When i save and see this report in ipad, i still see this as normal table but not as a map.

I have few questions,

-What is datatype of respective fields (poiname,latitude,longitude) to store in database.

-Should i modify anything while retrieving the data.

I think my mistake may be how i am inserting the data or table schema in database

Please provide your suggestions.

Thanks,

Niranjan

[Former Member · Accepted solution]

I mistakenly mark this as answered.

Please provide your suggestions..

-Niranjan

[Former Member · Accepted solution]

I dont know if it helps, but I had some error like that, leave the parenthesis out and try again:

map_lt(3),lo(4)_poi(2) --> map_lt3,lo4_poi2

Hope it helps, with me it worked.

[Former Member · Accepted solution]

Hi ,

yes without the paranthesis , it worked fine.

But i have another problem with opendocument link URL.

documentation tells that opendocument url will be in below format

"doc cuid/report name/report part name"

But how to pass the POI value to child report to display only related data.

Link just refers to the document in repository. And there are no other parameters defined in this format.

My question is how to pass the POI value to child report.

If I tap on the city POI (say NewYork), it has to pass the NewYork city value to child report and display only it's correspoding data in the pop up window.

I defined a prompt in child report on city, but how to pass this value

Is this feature is not available in geomaps or am i missing some syntax.

Any help greatly appreciated.

thanks,

Niranjan

[Former Member · Accepted solution]

In the documentation there's no clue about how to do this, and the way I tried, I wasn't able to make it work properly.

What I did is make a report with various blocks, each block filtered for each value. I know it sounds terrible, but if you build one "general" block (matrix) you can copy it by pressing and holding the ctrl key and move this block. Once you have a copy you can apply a filter to that block for example --> apply filter to dimension CITY = "New York". and rename the block NewYork.

On the opendocument column, you should type --> UID/"Tab Name"/BlockNewYork

I also hope that some functionality will be improved to have not only this type of filters, but to show some filters in the screen as well.

Until then, I guess we should keep on making blocks like this.

Regards,

[Former Member · Accepted solution]

Hi ,

Yeah i tried in different ways and seems like it is limitation of the features at present.

I thought it may have different syntax.

Thank you for your suggestion,

Yes, until this feature is available, we have to create multiple blocks in child report and name the block as per our requirement. (but it is tedious job if we have more no. of cities )

Any how thanks for your time and reply.

Regards,

Niranjan