Pricefx Classic UI is no longer supported. It has been replaced by Pricefx Unity UI.

 

How to Create Rollup


Aim of this articleExplains how to create a new Rollup (persisted Analytics queries aggregating measures along one or more dimensions).
Related sectionsRollups (Reference Manual)

Steps:

  1. Go to Analytics > Rollups.
  2. Click the Add icon. 
  3. Fill in the Label
  4. In the middle pane, select a Datamart from the Source drop-down list.
  5. Drag and drop fields from this Datamart to three different areas to create a query:
    1. Source & Filters section, where they become dimension filters. The dropped field must be marked as a dimension in the source.
    2. Group By section, defining the dimensions along which to roll up the projected measures. (See also a note on Integers as dimensions.)
    3. Measure section, where additionally an aggregation function can be specified to complete the query definition.
  6. At any point where the query under construction is valid, it can be saved by clicking the Save  icon in the header of the Source & Filter section. The name of the Rollup being saved is reflected in the section's header.
  7. Click the Run now  icon and inspect the results in the Data section. For queries on large sources, this can take several minutes.

Found an issue in documentation? Write to us.