📝 Note: This is part of the Fast Track and a mandatory exercise.
In this exercise, we will setup a story in SAP Analytics Cloud, which allows us to do a Year over Year comparison of our revenue information
- Log On to your SAP Analytics Cloud tenant.
💡 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 first example, we will use the Analytical Data Set – Sales View – Analytical Dataset.
-
Click OK.
-
Select the option to add a Chart.
-
Now select the newly created empty chart on the canvas.
-
Navigate to the Builder Panel on the right hand side.
-
Click Add Dimension as part of the Dimensions section.
-
Select Transaction Date.
-
Click Add Measure as part of the Measures section.
-
Select measure Revenue.
-
Now click on the hierarchy icon for dimension Transaction Date in the Builder Panel.
-
Select the option Set Hierarchy.
-
Select the entry Year, Quarter, Month, Day.
-
Click Set.
-
Now click on the hierarchy icon for dimension Transaction Date in the Builder Panel a second time.
-
Select the option Level 4 – which represents the Month level.
-
Your chart should look similar to the image shown below.
-
So instead of looking at two years of data, we want to look at the current year – 2022 – and see the variance compared to the last year data.
-
Click on the Filter icon for dimension Transaction Date.
-
Select the option Filter by Member.
-
Open the list of members and select the year 2022.
-
Click OK
-
Now click on the hierarchy icon for dimension Transaction Date in the Builder Panel.
-
Select the option Level 3 – which represents the Month level now as we selected a Year as entry point.
-
Open the More menu for the chart (top right corner).
-
Select the menu Compare to
-
Select the option Previous Year.
-
Your chart should look like this.
-
In the File menu select the option "save" to save your story.
-
Create a User folder that matches your Space name, e.g. GE12345.
-
Enter a Name and Description like Year over Year comparison.
-
Click OK.
You've now created your first SAP Anayltics Cloud Story on top of the data model you created earlier.
Continue to - Exercise 13: Revenue by Geography (requires Exercise 08 to be completed)