What are aggregates/aggregate tables and where is it used?

• Related Articles

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

• 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 are the duplicate aggregates in admin module and aggregates defined in metadata file not appearing in the browser?

  This problem can occur if sequence numbers are empty in mssql_dbmodel.xml file. To solve the problem, provide sequence number in mssql_dbmodel.xml file.

• The parameter used in an aggregate table that refers a view sql does not work. What could be the reason?

  Parameter defined in the "view SQL" query should not be enclosed with single quotes. Attached screen print can be referred

• After Publishing the KPI with Calendar(Business/Gregorian) its not referring the correct Aggregates. How to fix this?

  This issue occurs if the Graph linked to the KPI does not have calendar filter. So even if the KPI with Calendar Filter hits to proper respective Calendar Aggregate Table, after analyzing KPI, its hits the Standard Aggregate Table. To fix this issue, ...