Creating a Table

You can add a table to any SAP Analytics Cloud story or analytic applications page.

You can create a blank table or a table based on an existing model.

Models based on remote live data depend on connections that an administrator creates using the Connections feature.

When your existing model is a planning model, you have two choices for the type of table to create:
  • Cross-tab: displays the data that is grouped or totaled in two directions. This is the default table.

  • Forecast Layout: displays the data divided into several time periods, allowing you to look back or look ahead.

    For more information, see Creating a Forecast or Rolling Forecast Layout.

Remember
If your story already has a model or data source on any page, that data source is used automatically for new models added to Canvas or Responsive pages. If there is more than one data source, the most recently used one is applied to new tables.
Note
If you have a lot of data to retrieve when your table is initially created, it may take some time for the table to finish loading it all. To help speed up load time, your new table will open using the following criteria:
  • Rows contains “Account” and will be filtered to the first account.

  • The drill level is set at 1.

  • Columns contains “Version” and will be filtered to the first version.

    In many cases, the first version will be “Actual”.

Add a Table to a New Story or Analytic Applications Page

  1. To add a table to your story or analytic applications page, do the following:
    • Stories:
      1. From the (Main Menu), select Start of the navigation path(Stories) Next navigation step CanvasEnd of the navigation path.

      2. Select Table.
    • Analytic applications:
      1. From the () Main Menu, select Start of the navigation path (Analytic Applications). Next navigation step  ApplicationEnd of the navigation path.

      2. Select Start of the navigation pathInsert Next navigation step TableEnd of the navigation path
  2. In the Select Model dialog, select a folder and then select a data source:
    • Public: either search through the public folder for an existing model, spreadsheet, or other data source, or select the Models folder and then select a model.

    • Samples: select a model.

    If prompted, provide the proper login credentials for your data source connection.

The default table type is an optimized presentation table. You can change the table type in the Builder panel by clearing the check box for Optimized Presentation. For more information on the default table, see Optimized Presentation Table: Features and Restrictions.

Add a Table to an Existing Story or Analytic Applications Page

To add a table to an existing story or analytic applications page, do the following:
  1. From the (Main Menu), select Files.

  2. Select your story or analytic application.

  3. If you cannot edit the story or analytic application, select Edit.

  4. From the toolbar, under Insert, select Table.

    A table is added to your page.

  5. A data source will automatically be selected for your new table. To change it, in Start of the navigation pathBuilder Next navigation step Data SourceEnd of the navigation path, select (change primary model) and choose a new data source.

    If prompted, provide the proper login credentials for your data source connection.

Use the Builder tab to select the dimensions to include in the rows and columns.

Use the Styling tab to customize the look of the table.