Skip to content

Latest commit

 

History

History
120 lines (64 loc) · 4.39 KB

README.md

File metadata and controls

120 lines (64 loc) · 4.39 KB
Raw

Exercise 8 - Top 10 Revenue Generating Products

In this exercise, we will create a story in SAP Analytics Cloud (SAC), which allows us to analyze and identify the top 10 revenue generating products.

  1. Log On to your SAP Analytics Cloud tenant.

💡 Note: The system might prompt you to sign in again. Use the same username and password for SAC as you do for Datasphere.

  1. Select the menu Stories in the left-hand panel.

  2. Select the option Canvas to create a new story.

  3. Select Optimized Design Experience when asked which design mode to use. Click Create.

  4. Under Widgets, select and drag Chart onto the canvas.

  5. To select the model that you want to reference in your story:

    • Select DWC as the connection on the left panel.
    • Select your space, e.g., GE123456, and the folder TECHED2024-DA180.
    • For our first example, select your Sales - Analytic Model.

  6. Now select the newly created empty chart on the canvas.

  7. Navigate to the Builder panel on the right-hand side.

  8. Click Add Dimension as part of the Dimensions section.

  9. Select Transaction Date and Product ID. Afterwards, click anywhere outside the view for dimensions selection to return to the chart settings.

💡 Ensure the Transaction Date is positioned first within the dimensions section overview.

  1. Add a measure by clicking on the At least 1 Measure required section.

  2. Select the measure Revenue. Afterwards, click anywhere outside the view for measure selection to return to the chart settings.

  3. Click on the Filter icon for the dimension Transaction Date.

  4. Select the option Filter by Member.

  5. Open the list of members and select the year 2022. Click OK.

  6. Open the More Actions menu (...) for the chart (top right corner of chart). Within the menu, go to Rank > Top N Options > Update value to 10. Click Apply.

  7. Update Chart Orientation to Horizontal in the Builder Panel.

  8. You can adjust the size of the chart by clicking and dragging the brackets outward or inward. Additionally, you can move the y-axis to ensure the full product name is displayed.

  9. Your chart should look like this. Note that only the description of the product is displayed, based on the configuration in Display Options for Product ID.

  10. We want to visualize the change in revenue over time using an additional chart. Drag a new chart onto the canvas to get started.

  11. Set the following settings:

    • Select Line as Currently Selected Chart.
    • The measure for Left Y-Axis is Revenue.
    • Select Transaction Date as Dimension.
    • Filter Product Category ID (Member) to Juices.

  12. Use the time hierarchy defined for Transaction Date to perform a quarter-based analysis. Set the hierarchy to Year, Quarter, Month, Day by clicking on Change Hierarchy. Adjust the level to Level 3 so that the revenue is displayed per quarter.

  13. You can now modify the style of your story and add elements, headings, or adjust chart titles. If you select + (Insert section), you will see options to insert standard shapes or other entities, such as dynamic text.

  14. In the File menu, select the option Save to save your story.

  15. Create a folder that matches your space name, e.g., GE123456.

  16. Select the folder GE123456. Enter a name and a description, such as Revenue Analysis - Products.

  17. Click OK.

Summary

You've now created your first SAP Analytics Cloud story based on the data model you built earlier.

Continue to - Exercise 09: Revenue by Geography