Technical Articles
SAP BTP Data & Analytics Showcase – How to visualize geospatial data from SAP Data Warehouse Cloud in SAP Analytics Cloud
Introduction
The following blog post refers to a series of blogs around SAP’s Business Technology Platform, which shows an end-to-end scenario across the SAP HANA Database & Analytics Portfolio. This is part three out of three, and shows how to visualize data coming from SAP Data Warehouse Cloud. The data is coming from the Tankerkoenig API, processed in SAP Data Intelligence Platform, SAP Data Warehouse Cloud and exposed as an Analytical View. This view is consumed in SAP Analytics Cloud. For further information regarding the scenario, I recommend to read the overview blog.
In this scenario we are using SAP Analytics Cloud Enterprise Edition.
Step 1: Create a connection from SAP Analytics Cloud to SAP Data Warehouse Cloud
There are two ways to work with SAP Analytics Cloud on top of SAP Data Warehouse Cloud:
- Remote live connection
- Space-aware connection
The space-aware connectivity is only recommended for testing purpose and not for a productive use. That is the reason for using the remote live connection in this example. In the remote live connection scenario SAP Analytics Cloud and SAP Data Warehouse Cloud can run on different tenants, and even in different data centers. However, SAP Analytics Cloud in combination with live connection to SAP Data Warehouse Cloud has some unsupported features. For further information, I recommend this SAP Note.
Before setting up the live connection in SAP Analytics Cloud, you need to add the URL as trusted origin in SAP Data Warehouse Cloud system.
Login to your SAP Data Warehouse Cloud tenant and switch to your embedded Analytics application (you have to login as an administrator).
Figure 1: Switch to embedded Analytics application
Navigate to System – Administration and click on the tab App integration
Figure 2: Navigate to Administration
Enter the URL of your SAP Analytics Cloud tenant as a trusted origin. If there are multiple SAP Analytics Cloud tenants on one data center, I would recommend using a wildcard by adding * for subdomain matching.
Figure 3: Add a Trusted Origin
After adding your SAP Analytics Cloud URL as a trusted origin, you can add SAP Data Warehouse Cloud as a connection in your SAP Analytics Cloud tenant.
In SAP Analytics Cloud navigate to Connections and select Connect to Live Data – SAP Data Warehouse Cloud
Figure 4: Create connection to SAP Data Warehouse Cloud
Figure 5: Connection Details
Step 2: Create SAP Analytics Cloud Story with Geo Map
Figure 6: Select data source
Figure 7: Select connection, space, analytical view
You can use the created HANA ST_POINT Dimension from SAP Data Warehouse Cloud as the location dimension in SAP Analytics Cloud.Figure 8: Geo Map in SAP Analytics Cloud based on SAP Data Warehouse Cloud
Figure 9: SAP Analytics Cloud Story
Summary
In this blog post we have showed you how to connect SAP Analytics Cloud via remote live connection to SAP Data Warehouse Cloud as well as to create a geo map in SAP Analytics Cloud. Additionally, you got an impression how an end-to-end scenario with SAP Software-as-a-Service solutions could look like, including information how the solutions are integrated.
In the future, we aim to to predict the gas prices and we have many more exciting ideas to expand this blog, so stay tuned.
Finally, I would like to say thank you to my colleagues Wei Han, Axel Meier and Jonas Mittenbuehler, who helped to make this end-to-end demo story happen together! Thank you!