Exercise 14 - Best Salesperson

📝 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 based on our Consumption Layer, and review who our best salesperson is.

💡 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 third example, we will use the Perspective we created previously Revenue by Store and Product (Perspective)
Click OK.
Select the option to add a new Chart to the canvas.
Navigate to the Builder Panel on the right hand side.
Click the option Add Dimension as part of the Dimensions section.
Select the option Create Dimension Input Control.
Select the entries:
- Dimension Store
- Product
- Sales Manager

Click OK.
On your canvas you will then be presented with a token for the newly created Dimension Input Control.
Select the token and resize the token so that you can see all entries.
Now use a double click on the header of the Dimension Input Control and enter: Please select a dimension.
Select the empty chart.
Navigate to the Business Builder Panel on the right hand side.
Click the Add Measure option for the Measures section.
Select measure Revenue.
Now open the More Actions menu for the chart.
Select the menu Rank.
Select the option Top N Options.
Set the Value to 10.
Click Apply.
You should now have a chart showing the Top 10 entries based on the dimension selected with the input control and based on the Consumption Layer created in SAP Data Warehouse Cloud.
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 Best Salesperson.
Click OK.

Summary

🏆 Congratulations you have now completed the exercises for this session!