Data Grid

SAP Analytics Cloud Responsive Page employs a grid-based layout system, where widgets snap into place, providing a consistent design across different screen sizes and orientations.

1. Select the Main Menu icon in the top left.

2. Select Stories and select Responsive.

3. In the Assets panel on the left of the screen, drag and drop the Table widget onto the Story canvas area.

4. Leave the Existing Model radio button selected, then choose Select other model… from the open drop-down menu.

5. Follow the file path My Files > Public > Experience Academy - SAC Planning > Models then choose PnL_CH1.

This is a multi-dimensional model that has already been populated with Dimensions (some with hierarchies), Measures and Versions.

6. Expand Net Income, then Operating Income by clicking on the arrow “>”.

8. Under Columns, click + Add Dimensions.

9. Select Date by clicking on the checkbox to the left of it.

10. Expand (all) in the Grid Column by selecting the arrow next to Date.

Note : You now see the data values spread over the years 2018, 2019 and 2020.

11. In the Builder, hover over the Date dimension in Columns - you will see a filter icon appear:

12. Select on the filter icon.

13. Select Filter by Member.

14. Select 2019 and 2020.

15. Select OK.

16. You’ll see the grid now only shows 2019 and 2020.

17. Remove Date Dimension from the Columns by selecting X.

18. Select + Add Dimensions under Columns.

19. Select Organization.

20. Expand the arrow icon beside World to show the geographical breakdown of the data.

21. Select on Page 1, select the down arrow, and select Edit Title.

22. Enter “Net Income Report” as the new page name and hit the return key.

23. Select on the Save icon.

24. Name the report Admin_FirstReport.

25. Select Save when finished. This saves our initial story.

Note: The report is now saved in your personal My Files folder.

SAP Analytics Cloud Responsive Page employs a grid-based layout system, where widgets snap into place, providing a consistent design across different screen sizes and orientations.

1. Select the Main Menu icon in the top left.

2. Select Stories and select Responsive.

3. In the Assets panel on the left of the screen, drag and drop the Table widget onto the Story canvas area.

4. Leave the Existing Model radio button selected, then choose Select other model… from the open drop-down menu.

5. Follow the file path My Files > Public > Experience Academy - SAC Planning > Models then choose PnL_CH1.

This is a multi-dimensional model that has already been populated with Dimensions (some with hierarchies), Measures and Versions.

6. Under Rows click + At least 1 Account required to add an Account.

7. Select Net Income.

8. Under Columns select + Add Dimension.

9. Select Version.

10. In the table, expand the Accounts Net Income, then Operating Income.

11. Under Columns, click + Add Dimension.

12. Select Date by clicking on the checkbox to the left of it.

13. Expand (all) in the Grid Column by selecting the arrow next to Date.

Note : You now see the data values spread over the years 2018, 2019 and 2020.

14. Under Columns, hover on the Date dimension and select the filter icon then select Filter by Member…

15. Select 2019 and 2020 then click OK.

16. You can see that the table now only displays values for 2019 and 2020.

17. Remove Date from Columns by selecting X icon.

18. Click + Add Dimensions under Columns and select Organization.

19. Expand the arrow icon beside World to show the geographical breakdown of the data.

20. On the Page_1 tab, select the down arrow, and then select Edit Title.

21. Enter Net Income Report as the new page name and hit the return key.

22. Select the Save icon, then Save.

23. Enter the Name as Admin_FirstReport then select Save. This saves our initial story.