Skip to Content
Product Information
Author's profile photo Ingo Hilgefort

SAP Data Warehouse & SAP Analytics Cloud – New Geo Enrichment

Please note, that the below is showing an upcoming feature of the SAP Data Warehouse Cloud integration with SAP Analytics Cloud. This feature is being planned for delivery towards end of next month.

Disclaimer:

This presentation, or any related document and SAP’s strategy and possible future developments, products and or platforms directions and functionality are all subject to change and may be changed by SAP at any time for any reason without notice.

 

Today we are going to take a look at an new upcoming feature for the integration of SAP Analytics Cloud with SAP Data Warehouse cloud, which is the Geo Enrichment of data directly within SAP Data Warehouse Cloud.

Here is our overall scenario:

  • Uploading the Geo Information for the dimension
  • Create the Dimension View and configure the Geo Enrichment
  • Add the Dimension View to the Analytical Data Set
  • Leverage the Geo relevant information in SAP Analytics Cloud

For our sample scenario we are using a set of retail transaction which contain the City in the US as column and a second set of data with the US cities and the geo relevant information.

Uploading Geo Information

As first set of steps we will upload the geo information for the dimension into SAP Data Warehouse Cloud and create the table for it.

  1. We login to SAP Data Warehouse Cloud.
  2. Navigate to the Data Builder.
  3. On the start screen of the Data Builder select the option to import a CSV File.
  4. Select the CSV File with the Geo relevant information.
  5. In our example the file has the following structure
City State ID State Name lat lng
New York NY New York 40.6943 -73.9249
Los Angeles CA California 34.1139 -118.4068
Chicago IL Illinois 41.8373 -87.6862
Miami FL Florida 25.7839 -80.2102
Dallas TX Texas 32.7936 -96.7662
  1. Import the CSV file and ensure that the data type for the column for longitude and latitude is set to Number.
  2. After you imported the file, open the table in the Data Builder.
  3. Ensure the Data Type for Longitude and Latitude is set to Decimal.
  4. Ensure the table is saved and deployed.

 

Creating the Dimension View

After we uploaded the information for all cities, we will now create the Dimension View and configure the Geo Enrichment based on the Longitude and Latitude values.

  1. In SAP Data Warehouse Cloud navigate to the Data Builder.
  2. Navigate to the Data Builder.
  3. Select the option New Graphical View.
  4. On the left hand side you can see your previously created table.

  1. Drag and Drop the table from the Repository to the canvas.

  1. Select the node View 1 on the canvas.
  2. Navigate to the Details panel on the right-hand side.

  1. Set the following Details:
    • Business Name: US Cities Geo Dimension
    • Technical Name: US_Cities_Geo_Dimension
    • Semantic Usage Dimension
  2. Select the node US Cities on the canvas.

  1. Select the option to add a node for Calculated Columns.
  2. Select the new node “fx” for the Calculated Columns on the Canvas.
  3. Navigate to the Details on the right-hand side.

  1. Click on the “+” sign and select the option Geo-Coordinates Column.
  2. You can now map the columns from the source table to the configuration for Latitude and Longitude.

  1. Map those columns.
  2. Enter the following details:
    • Business Name US City Location
    • Technical Name US_City_Location

Please note, that this is the name of the Location Dimension in SAP Analytics Cloud.

  1. Click on the term “Columns” in the header of the panel to navigate back.
  2. Save the View
  3. Deploy the View

 

Adding the Dimension View to the Analytical DataSet

We have the dimension with the Geo relevant information now and can now create our Analytical Data Set and add the Geo Dimension as an Association to our View.

  1. Login to SAP Data Warehouse Cloud.
  2. Navigate to the Data Builder.
  3. On the start screen of the Data Builder select the option to import a CSV File.
  4. Select the CSV File with the fact data.
  5. Import the file and Deploy the table with the name Retail Sample Data.
  6. Navigate to the Data Builder.
  7. Select the option New Graphical View.
  8. On the left hand side you can see your previously created table.

  1. Drag and Drop the table Retail Sample Data from the Repository to the canvas.
  2. Select the node View 1 on the canvas.
  3. Navigate to the Details on the right hand side.

  1. Enter the following Details:
    • Business Name Retail Sample Analytical Data Set
    • Technical Name Retail_Sample_Analytical_Data
    • Semantic Usage Analytical Data Set
    • Expose for Consumption On / Enabled
  2. In the Details panel scroll down to the list of Attributes.
  3. Navigate to the Attribute Sales.
  4. Ensure that you have at least one Measure defined.
  5. In the Details panel scroll down to the area Associations.

  1. Use the “+” sign to create a new Association.

  1. Select the Dimension View US Cities Geo Dimension which we created previously.
  2. Click OK.

  1. In the panel on the right hand side ensure that the Join is based on dimension City.
  2. Save your changes.
  3. Deploy the View.

 

SAP Analytics Cloud – Using the Geo Information

We now have the view in SAP Data Warehouse Cloud and we can leverage the information in SAP Analytics Cloud.

Please note, that the following steps require a Live Connection towards the SAP Data Warehouse Cloud tenant to be configured in SAP Analytics Cloud.

  1. Login to SAP Analytics Cloud.
  2. Select the option to Create a new Story.
  3. Select the option to use a Canvas page.
  4. In the top left of the toolbar, select the option Data.

  1. Select the option to add Data from a Data Source.

  1. Open the list of Live Data Connections.
  2. Select the entry SAP Data Warehouse Cloud.

  1. Select the Connection.
  2. Click OK.
  3. Select the Space from SAP Data Warehouse Cloud.
  4. Click OK.
  5. Select the Analytical Data Set.
  6. Click OK.
  7. Select the option to add a Geo Map.
  8. Navigate to the Builder Panel on the right hand side.

  1. Click Add Layer for the option Content Layers.
  2. Click Add Location Dimension for the option Location Dimension.

  1. Select the entry US City Location, which is what we created as part of our SAP Data Warehouse Cloud model.
  2. Click Add Measure / Dimension for the Bubble color.
  3. Select measure Profit.
  4. Click Add Measure for the Bubble Size.
  5. Select measure Sales.
  6. Click OK (bottom right).

 

As you can see, with a few steps we were able to enrich our data in SAP Data Warehouse Cloud with the relevant Geo information, add the Geo information to our view, and then simply leverage the information in SAP Analytics Cloud.

With this first step on the Geo Integration, we do support the Bubble Layer, Heat Layer, and the Flow Layer. Support for the Choropleth Layer and the ability to leverage regional information (like country and region) instead of longitude and latitude, is planned as well and will come soon.

 

Assigned tags

      8 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Mohammed Abdul Imran
      Mohammed Abdul Imran

      Awesome feature. Looking forward to use it. Thanks Ingo Hilgefort  for sharing this

      Author's profile photo James Giffin
      James Giffin

      Ingo Hilgefort I see the dropdown has SRID 4326.  Will we be able to use other SRIDs?

      Author's profile photo Ingo Hilgefort
      Ingo Hilgefort
      Blog Post Author

      Hello James,

      right now it lists those SRID that are available in the HC system. There is a plan to provide an option to deploy additional items.

      Best Regards

      Ingo Hilgefort, SAP

      Author's profile photo Melanie Wobbe
      Melanie Wobbe

      Hey Ingo, great blog! I tested it in our Demo Sandbox system - it works fine 😉

      Many thanks!

      Author's profile photo Xavier Polo
      Xavier Polo

      thanks for the info. Will it be available when using the business layer?

      Author's profile photo Ingo Hilgefort
      Ingo Hilgefort
      Blog Post Author

      Hello Xavier

      Author's profile photo Klaus Freyburger
      Klaus Freyburger

      Hi Ingo,

      great blog, thanks!

      Support for the Choropleth Layer and the ability to leverage regional information (like country and >region) instead of longitude and latitude, is planned as well and will come soon.

      Any news on this?

      Thanks

      Klaus

      Author's profile photo Ingo Hilgefort
      Ingo Hilgefort
      Blog Post Author

      Hello Klaus,

       

      yes those items are planned as well

       

      Ingo