Use of Choropleth Map in SAP Analytics Cloud (SAC) with SAP Data Warehouse (DWC) Live Connection

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:

Master%20Data%20%u2013%20Dimensions%20and%20Measures

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%20Data%20%u2013%20Geo%20Information

Master Data – Geo Information

For this we create a calculated column for the geo-coordinates in the dimension view:

create%20Geo-Coordinates%20Column

create Geo-Coordinates Column

Define%20Geo-Coordinates%20Column

Define Geo-Coordinates Column

The dimensions view now provides the following information about the building:

Dimension%20View%20-%20Output

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%20of%20Dimension%20View

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%20Layer%20Type%20and%20Location%20Dimension

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%20Measure%20per%20Country

Show Measure per Country

Drill%20down%20to%20State

Drill down to State

Drill%20down%20to%20Region

Drill down to Region

Drill%20down%20to%20City

Drill down to City

Drill%20down%20to%20Location

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