Tables can be used to view and analyze data. Tables are added to either responsive or canvas pages in stories.
For tables that are based on models, the set of features and options available depends on the model type (planning, analytics, or a model based on a remote SAP HANA system). Only the features and options that are supported by the model type are visible. For example, tables based on planning models allow users to make changes to the model data using version management, data entry, and allocations; but tables based on analytic models are read-only.
When you add a table to a story, a data grid is created with the basic dimensions and categories of the model aligned along the axes of the grid. You can change this basic layout using the following designer tools:
Use the Builder pane to select the measures and dimensions to include in the rows and columns of your table.
Use the Styling tools to format the presentation.
You can add multiple measures and multiple dimensions to your table. When measures or dimensions are part of a hierarchy, you can expand them and select their level. If a dimension has properties associated with it, you can display those in the table, even without the dimension being present in the table. You can also apply filters to your measures and dimensions. The table is updated as you make your choices in the builder.
The following figure notes some of the options when configuring the table.
The Auto-size and Page Table Vertically setting can be used to scroll through the rows of a long table in View mode.
You can display a bar chart in your table cells so that you have both a visual and a numeric view of your data. In the table, right-click a column or row header containing a measure or member of an account dimension, and then select In-Cell Chart.