Data Grid
Objective
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.
- Select the Main Menu icon in the top left.
- Select Stories and select Responsive.
- In the Assets panel on the left of the screen, drag and drop the Table widget onto the Story canvas area.
- Leave the Existing Model radio button selected, then choose Select other model… from the open drop-down menu.
- 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.
- Under Rows click + At least 1 Account required to add an Account.
- Select Net Income.
- Under Columns select + Add Dimension.
- Select Version.
- In the table, expand the Accounts Net Income, then Operating Income.
- Under Columns, click + Add Dimension.
- Select Date by clicking on the checkbox to the left of it.
- 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.
- Under Columns, hover on the Date dimension and select the filter icon then select Filter by Member…
- Select 2019 and 2020 then click OK.
- You can see that the table now only displays values for 2019 and 2020.
- Remove Date from Columns by selecting X icon.
- Click + Add Dimensions under Columns and select Organization.
- Expand the arrow icon beside World to show the geographical breakdown of the data.
- On the Page_1 tab, select the down arrow, and then select Edit Title.
- Enter Net Income Report as the new page name and hit the return key.
- Select the Save icon, then Save.
- Enter the Name as Admin_FirstReport then select Save. This saves our initial story.
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.
- Select the Main Menu icon in the top left.
- Select Stories and select Responsive.
- In the Assets panel on the left of the screen, drag and drop the Table widget onto the Story canvas area.
- Leave the Existing Model radio button selected, then choose Select other model… from the open drop-down menu.
- 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.
- Under Rows click + At least 1 Account required to add an Account.
- Select Net Income.
- Under Columns select + Add Dimension.
- Select Version.
- In the table, expand the Accounts Net Income, then Operating Income.
- Under Columns, click + Add Dimension.
- Select Date by clicking on the checkbox to the left of it.
- 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.
- Under Columns, hover on the Date dimension and select the filter icon then select Filter by Member…
- Select 2019 and 2020 then click OK.
- You can see that the table now only displays values for 2019 and 2020.
- Remove Date from Columns by selecting X icon.
- Click + Add Dimensions under Columns and select Organization.
- Expand the arrow icon beside World to show the geographical breakdown of the data.
- On the Page_1 tab, select the down arrow, and then select Edit Title.
- Enter Net Income Report as the new page name and hit the return key.
- Select the Save icon, then Save.
- Enter the Name as Admin_FirstReport then select Save. This saves our initial story.
