Consolidation

Consolidation allows you to group attributes to define a virtual attribute, which does not exist in the project schema. This virtual element could be placed on a report just like an attribute and is calculated on the Intelligence Server side, causing no load on the database. The consolidation element does not have to be based on a single attribute. Also, we cannot group metrics using consolidations. The two main uses of consolidation are:

• To create a virtual attribute
• To perform row-level math

Consolidation elements

Attribute elements define the consolidation. They can be any of the following:

• Elements from the same attribute, such as month-January and February
• Elements from different attributes in the same hierarchy, such as month and quarter from the time hierarchy
• Elements from different attributes in different hierarchies, such as month from the time hierarchy, and region from the territory hierarchy
• Elements from the same consolidation
• Elements from different consolidations within...