Viewing the text data

In SAP Analytics Cloud, you can use the table object to view your model data. A table is a spreadsheet-like object that can be used to view and analyze text data in a model. For further details on this object, see Chapter 7, Working With Tables and Grids. Execute the following steps to view the data of the three versions in a table object:

1. On your story page, click on the plus icon on the page toolbar, and select Grid to add a grid page to the story.
2. On the new grid page, click on the Add icon on the toolbar to add a table object.
3. In the Select Model dialog, select the first Existing Model option (A), and then select StoresData (B) from the Name list. Click on OK.

In the Builder panel, set the following properties for the table object:

1. Click on the Add Measures/Dimensions link (A) in the Rows section, and select the Store dimension.
2. Again, click on the same link, and select the Date dimension.
3. In the Columns section, click on the Add Measures/Dimensions link, and select Version.

1. Hover your mouse pointer over the Version dimension, and click on the Manage Filter icon.
2. In the Selected filters for Version dialog, select all the three versions, as illustrated in the following screenshot:

The output of your selections is depicted in the following screenshot. The Store and Date dimensions occupy the row position, while the three data versions appear in separate columns. The Date dimension is presented as a hierarchy, with year, quarter, and month nodes. Monthly figures are rolled up into quarter and then into year: