One of the common requirements we see for maps for SAP BusinessObjects is creating geographic choropleths / heat maps. In this scenario, you can view common administrative areas or custom territories (country, state, etc) with a single measure at a time. In this article, I wanted to share an approach that my team has been championing with customers over the last 6 months. The idea is to use SAP Dashboards as rapid designer for embedded analytics. Most important, we can use the HTML5 output, not just as Flash. With SAP tools themselves having limited integration, we wanted to figure out a good way to get as close to possible for "design once deploy everywhere" when it comes to maps.
Notice: The instructions in this tutorial rely on third party, certified integrations for SAP. If you are not interested in reviewing solution using third party tools, this may not be an article of interest.
Required SAP Software:
SAP Dashboards for BI4.1
SAP Design Studio
SAP BusinesObjects 4.1 SP03-SP04 preferred
Required Third Party Tools:
Dashboards: CMaps Plugin for mapping
Webi: CMaps Analytics Webi Extension (included with CMaps Plugin)
Design Studio: APOS Dashboard Migrator for Design Studio
The concept of a choropleth is simple! Use the values from a measure to drive color intensity from high to low in a geographic map. This kind of visualization is good for quickly identifying outliers (high and low). However, Choropleths when used against geographic boundaries can be deceptive for several reasons.. View Choropleths and Heatmaps Intro and Best Practices for more details.
Without going into click by click steps, I have highlighted the important steps to produce a US Choropleth across all of the major SAP tools. I provide the project source files below:
Create your Choropleth in SAP Dashboards
(download the complete dashboard template here)
All of the above steps can be easily reversed engineered in this free template along with a copy of CMaps Plugin
Now we have our functional choropleth with hardcoded data that we can connect to a live query, or prepare it for use with Webi and Design Studio
Prepare for Webi and Design Studio:
For embedding SAP Dashboards in Webi or Design Sutido, you will need to create an external interface inside of SAP Dashboards using the Data Manager.
For Webi, create an external interface with the following properties:
Range Name: GetReportData
Range: Bind it to the data range containing the raw data for your map. This range will automatically be replaced by a Webi report part data.
Access: Read/Write
For Design Studio, create an external interface with the following properties:
Range Name: Range_0
Range: Bind it to the data range containing the raw data for your map. This range will automatically be replaced by a Webi report part data.
Access: Write
That's it! Your map is now ready for use with Webi and Design Studio.
Export your Geographic Analytic to the SAP BusinessObjects repository
You will need both of these values for Webi and Design Studio publishing. APOS Dashboard Migrator for Design Studio does have a feature to browse the repository and quickly get this information.
Embed and View your Geo Heatmap in Webi
This step requires installation of CMaps Analytics Webi Extension
View your Geo Heatmap in Design Studio
This step requires installation of APOS Dashboard Migrator for Design Studio
{"send":[{"range":"Range_0","dataDS":["Country Name","Population","Sales","Expenses"]}]
What's Next?
We are just scratching the surface for what is possible here, so I am excited to see how customers push us further to simplify and enhance these capabilities.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
12 | |
12 | |
7 | |
5 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 |