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