Webi report with map
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?
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.