This is a short blog to show how the SAP Analytics Cloud Choropleth Map can used with SAP Data Warehouse Live Connection.
New Functionality:
With the Release 2022.18 SAP Analytics Cloud now supports the Choropleth Layer in Maps for the Live Connection to SAP Data Warehouse Cloud. The Choropleth Layer enables business users to analyze their data by geographical area (Country, State, Region, City).
Modeling in SAP Data Warehouse Cloud:
To show how this works, I created a small example. I have an analytical view with global information about buildings and their assigned area:
First, we need the geo-coordination information on the building level. This information is in my Example available in the master data of the building with the longitude and the latitude fields. Based on this information I created a dimension view with a Building Location ID:
For this we create a calculated column for the geo-coordinates in the dimension view:
The dimensions view now provides the following information about the building:
In order to be able to use this information in the SAP Analytics Cloud as well, the dimension view is assigned as an association in the analytical reporting view:
Use of geo-information in SAP Analytics Cloud:
With this preparatory work in the SAP Data Warehouse Cloud, we can now use the geo-information about the building in the SAP Analytics Cloud.
In the Map you can now make flexible analysis and data exploration with the dynamic drill-down from country to city. You can now use the given hierarchy to drill down on the level you want to see. The map is linked with the table in the right side so that you can see the individual buildings of the level you are on in detail.
Business Value:
New Functionality:
With the Release 2022.18 SAP Analytics Cloud now supports the Choropleth Layer in Maps for the Live Connection to SAP Data Warehouse Cloud. The Choropleth Layer enables business users to analyze their data by geographical area (Country, State, Region, City).
Modeling in SAP Data Warehouse Cloud:
To show how this works, I created a small example. I have an analytical view with global information about buildings and their assigned area:
Master Data – Dimensions and Measures
First, we need the geo-coordination information on the building level. This information is in my Example available in the master data of the building with the longitude and the latitude fields. Based on this information I created a dimension view with a Building Location ID:
Master Data – Geo Information
For this we create a calculated column for the geo-coordinates in the dimension view:
create Geo-Coordinates Column
Define Geo-Coordinates Column
The dimensions view now provides the following information about the building:
Dimension View - Output
In order to be able to use this information in the SAP Analytics Cloud as well, the dimension view is assigned as an association in the analytical reporting view:
Association of Dimension View
Use of geo-information in SAP Analytics Cloud:
With this preparatory work in the SAP Data Warehouse Cloud, we can now use the geo-information about the building in the SAP Analytics Cloud.
Define Layer Type and Location Dimension
In the Map you can now make flexible analysis and data exploration with the dynamic drill-down from country to city. You can now use the given hierarchy to drill down on the level you want to see. The map is linked with the table in the right side so that you can see the individual buildings of the level you are on in detail.
Show Measure per Country
Drill down to State
Drill down to Region
Drill down to City
Drill down to Location
Business Value:
- Powerful geo-visualization with a broad selection of geo-maps and live connectivity to SAP Data Warehouse Cloud
- Simple Reuse of geo-enriched data from SAP Data Warehouse Cloud
- Flexible Analytics and Data Exploration with dynamic drill-down from country to city to location
- SAP Managed Tags:
2 Comments
