on 05-28-2013 10:05 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
To update myself, now there is a native, supported Google Maps extension for Webi HTML viewer: http://cmapsanalytics.com/webi.html
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/
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Marcello,
apologies, I thought you already had the information, see this blog entry
Thanks
Simone
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
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.