Exercise 13 - Geographic Revenue Distribution

📝 Note: This is part of the Fast Track and a mandatory exercise.

In this exercise, we will we will setup a story in SAP Analytics Cloud, which allows us to view the measures along a geographic map.

💡 Tip: The system will ask you to resign in.

Select the menu Stories in the left-hand panel
Select the option Canvas to create a new Story.
Select "Classic Design Experience" when asked "What design mode would you like to use?"
In the toolbar click on “Data” (top left) to add data from SAP Data Warehouse Cloud to your Story.
Select the option Data From Data Source.
Open the list Connect to Live Data.
Select the entry SAP Data Warehouse Cloud.
You will be asked to select Connection to SAP Data Warehouse Cloud.
Please select "SAPDWC" as the connection

When being asked to select your SPACE e.g. GE12345.
Click OK.
Afterwards you will be asked to select the Analytical Data Set or the Perspective from your Space.
For our second example, we will use the Analytical Data Set – Sales View – Analytical Dataset.
Click OK.
Select the option to add a Geo Map.
Resize the map, so that it uses the complete screen.
In the panel on the right hand side, select the option “Add Layer” for the Content Layer option.
As we only have one dataset right now, the data set from SAP Data Warehouse Cloud will be assigned to the new map layer.
Click on Add Location Dimension for the Location Dimension area
Select the option Store Location. This is the store location dimension we created previously based on the longitude and latitude values for the store dimension.
Click on Add Measure for the Bubble Size.
Select measure Revenue.
Click Add Measure / Dimension for the Bubble Color
Select measure Profit.
Now open the details for the measure Profit as part of the Bubble Color
Open the list of Color Palette.
Select the second entry from the Diverging category going from Red to Green.
Now open the details for the Bubble Size definition.
Set the size to 35%.
Your map should look like this.
In the File menu select the option to save your story.
Select the User folder that matches your assigned user number.
Enter a Name and Description like Geographic Revenue Distribution.
Click OK.

Summary

You've now created your second story based on the live connection to your data models in SAP Data Warehouse Cloud.