Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Rollups are persisted Analytics queries aggregating measures along one or more dimensions.

...

  1. Select a Datamart from the Data Source drop-down list.

  2. Create a query by selecting fields in the following sections:

    1. Generic Filter – Specify the filter criteria. You can combine individual rules with groups of rules as clauses and subclauses.

    2. Filters – Allows you to filter by all attributes from the product and customer master data.

    3. Group By section, defining the dimensions along which to roll up the projected measures. (See also a note on Integers as dimensions.)

    4. Measures section, where additionally an aggregation function can be specified to complete the query definition. For details see Data Calculation Options (note that not all options are supported by Rollups) and Number Formatting.
      Setting up either a group by or a measure is mandatory. 

  3. At any point where the query under construction is valid, it can be saved by clicking the Save Rollup button. You can save it as 'private' (visible only to you) or 'published' (visible to all users but only you or users with Manage Saved Rollups role can edit/delete it) or 'open for all' (visible and editable by any user).
    The saved Rollup will be available from the Load Rollup dialog under the assigned Label.

  4. Click the Apply and Refresh button and inspect the results in the data section. For queries on large data sources, this can take several minutes.

...