What is an Aggregate sequence?

• Related Articles

• What is Aggregate Sequence?

  Aggregate sequence is the sequence in which aggregate tables are stored in data model, with unique numbers. For every filter chosen by the user in the front end, there is an equivalent aggregate table mapped in the data model. When user choose ...

• 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.