What is Aggregate Sequence?

• Related Articles

• What is an Aggregate sequence?

  Each aggregate table defined in the dbmodel is stored in a particular sequence (based on which aggregate table to be referred as per the filters chosen) and provided a unique number to each. For every filter chosen in the front end, there is an ...

• Do all the aggregate tables specified in data model need to have a sequence number?

  All aggregate tables specified in the 'dbmodel.xml' have to be given a unique sequence number in order to apply the order of execution. And sequence is not just the running number for all tables; it has to be grouped by data mart. Please contact ARC ...

• Why is aggregate name in aggregate selection not sorted?

  The aggregate name is populated based upon the aggregate sequence defined in the dbmodel.xml file. Hence, it cannot be sorted.

• How to define sequence or order for tables in dbmodel ?

  You can define the order for aggregate tables through ?sequence?. See the below example..

• Which aggregate table will the KPI refer to fetch results when there are multiple aggregate tables?

  For the combination of measures and filters chosen in the KPI, if there are multiple aggregate tables then, you can define sequence for tables in the data model For Example, 1. 2. 5. 6.