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.

Select the Main Menu icon in the top left.

Select Stories and select Responsive.

Select Optimized Design Experience to use the new features of Story 2.0 for report design and Select Create.

Drag and drop the Table widget onto the Story canvas area.

Leave the Existing Model radio button selected, then select the Name dropdown and then choose Select other model.

Follow the menu path 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.

Note

The table is populated with data from the selected model.

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

Note

The following will be displayed.

Note

The panel on the right should by default be available showing Builder, if not click the

Under Columns, click + Add Dimensions.

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.

In Builder, hover over the Date dimension in Columns - you will see a filter icon appear:
Select on the filter icon.
Select Filter by Member.

Select 2019 and 2020.
Select OK.

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

Remove Date Dimension from the Columns by selecting X.

Note

Notice that the Filter is still valid for 2019 and 2020 and the data has been consolidated for both years. The filter is now shown in the Builder Filters section:

Select + Add Dimensions under Columns.
Select Organization.

Select on the arrow icon beside World to show the geographical breakdown of the data.

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

Enter “Net Income Report” as the new page name and hit the return key.
Select on the Save icon.

Name the report “Admin###_FirstReport” (### being your User ID).

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

Select OK when finished.
This saves our initial story.

Next lesson