Use Tables to Visualize Data

Tables can be used in SAP Analytics Cloud stories to view and analyze data.

For tables that are based on models, the available features and options depend on the model type (for example, planning, analytic, or other model types). 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.

Story Page Types: Canvas, Responsive, or Grid?

Some features may not be handled in the same way on all page types.

Features Canvas Responsive Grid
Using Models Tables are integrated with an underlying Model. Tables are integrated with an underlying Model. Tables may be related to a model but it is also possible to create blank tables and type or paste the data in manually.
Positioning Table tiles can be moved around just like other tiles. Table tiles can be moved around just like other tiles. You can change the position of the table by adding rows and columns above or to the left of the table.
Creating Input Tasks Select the table and in the Tools menu, select Create Input Task. Not Applicable Not Applicable
Designing Tables

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 Designer tools.

Use the Builder to select the measures and dimensions to include in the rows and columns of your table.

Use the Styling tools to enhance the presentation.

Use the Examine panel to create charts and visualizations based on selected areas of the data in your table.

You can add multiple measures and multiple dimensions to your table. When measures or dimensions are part of a hierarchy or when a dimension has attributes, you can expand them and select their children or expand a dimension and select its attributes. You can also apply filters to your measures and dimensions. The table is updated as you make your choices in the Builder.

Tips and Best Practices

Here are some tips and suggestions to improve your tables.

  • Be aware of drill limitations.

    To have decent performance for initial data queries, the result is limited to 500 rows by 60 columns. A warning is issued when the server would return more rows or columns for the given selection.
    Example
    “784 rows and 73 columns of data are requested, but the drill limit is set to 500 rows and 60 columns.”

    You can choose to either change the filters to return fewer results or edit the drill limits and retrieve more data.

    Remember

    Editing the drill limits changes the table results when you are viewing the story, but they aren't saved. To see the new table results the next time you open the story, change the drill limits and then save your story.