cancel
Showing results for 
Search instead for 
Did you mean: 

Webi report with map

Former Member
0 Kudos

Hi All,

I'd like to create a webi report with a map in it.

I've already read something about (like integrating google's api etc) but I'd like to know if there is an easier way.

Do you have any suggestion?

Regards,

Marcello

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Marcello:

  Tell me what do you need to do with the map? Have to be fully interactive?

I've done dummy things in Webi that users find to be amazing, by example:

1.- Took the US map with states and set it as background for my Webi report MAIN and only one page.

2.- Create variables by state and then place them in cells and drop it in each state location (one state variable by cell)

3.- When the user select certain condition from Input values or from the prompt, then the data (let's say: sales by state by that salesman) is display in each state....with percetage, Numbers an compared against average sales....paining in red is udner average or in green is over average...

Tell me more to see if I can help you more...

Reinaldo

Former Member
0 Kudos

Hi Reindaldo,

Thanks for the answer. I have to implement the last case, a sort of geo marketing.

Can you tell me more please?

Regards,

Marcello

Former Member
0 Kudos

Marcello, my bad...those weren't three separate cases....all those are part of the same case...

what you have to do is as follow:

1.- Select a JPEG file with the map you need to (not too big so it can load fast)

1.1.- Create a  Webi report and select this graph as the background...The path to do this is different in Xi 3.1 and BI 4.0. What version are you using?  IN BI 4.0 you have to be in Design>Structure Mode> Format Report> Appearance> Image from file

1.2 Once you have the icture of the map as the background for each page of the webi report, then you have to continue...step 2

2. If you report without prompts returns more that one row per salesman, let's say

Salesman State  Sales

SM1 North Carolina  $500

SM1 South Carolina $200

SM1 Florida              $300

SM2 North Carolina  $1100

SM2 South Carolina $900

SM2 Florida              $100

SM3 North Carolina  $2300

SM3 South Carolina $570

SM3 Florida              $750

Then you have to show one salesman per page (unless there is a small number of salesman that you can fix in a single page/Map)...You can use sections for each salesman and create variables per state:

vNC = If (State = "North Carolina") then Amount else 0

vSC = If (State = "South Carolina") then Amount else 0

vFL = If (State = "Florida") then Amount else 0

Insert an empty Cell in each State  of the MAP and assign each cell its variable by state...example...for the empty Cell you placed in Florida...make it = vFL..then it will display the amount for that State for that Salesman...

This maybe an example to compare Salesman performance by State, based in a single Item. It doesn't compare all Salesman by State.


So, when you go to the next page you will see the next Salesman, unless you place a prompt in the report to display a single salesman per report.

Reinaldo

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi guys,

Extension Points is back for BI4.1 so technically you can build maps directly into Webi by building your own extension which is fairly simple once you get going.

I documented my experience using extension points and embedding maps here:

Full disclosure I did document the process using a paid mapping solution that we built. Either way, I hope the information is useful.

Former Member
0 Kudos

To update myself, now there is a native, supported Google Maps extension for Webi HTML viewer: http://cmapsanalytics.com/webi.html

former_member185138
Participant
0 Kudos

Hi Marcello,

You can use GMAP's API or fusion tables to create the maps on Webi reports.

Below link will also help you.

http://bihappyblog.com/2012/01/20/google-maps-in-webi-4-0-mashup/

Former Member
0 Kudos

Did you have Business Objects Explorer available?  Explorer has some mapping features available for both desktop and mobile.  We have dabbled with the state level mapping.

Last fall at TechEd the WebI mapping features I saw were iPad ONLY...which didn't work for me.  I'd prefer to have a consistent desktop/mobile feature set.

former_member188911
Active Contributor
0 Kudos

Hi Marcello,

at present you can only use the suggestions you already found i.e. geomapping with extension points etc.

maybe in the future...

Thanks

Simone

Former Member
0 Kudos

Hi Simone,

Could you tell me where I can find some documentation about it?

Regards,

Marcello

former_member188911
Active Contributor
0 Kudos

Hi Marcello,

apologies, I thought you already had the information, see this blog entry

http://scn.sap.com/people/ted.ueda/blog/2008/12/20/integrate-google-maps-with-the-web-intelligence-r...

Thanks

Simone

Former Member
0 Kudos

Hi Simone,

I can't download JDICplus library from the link provided in the post. I haven't found a valid link to download the file.

Do you know where I can find a valid link?

Regards,

Marcello

Former Member
0 Kudos

Marcello:

I'm thinking more liely you would need to create an account (in http://java.net/projects) and login in order to access that download