Skip to Content
Product Information

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.

 

4 Comments
You must be Logged on to comment or reply to a post.