Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Webi report with map

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

Tags:
Former Member
Former Member replied

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

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question