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 ...
Get Mastering Business Intelligence with MicroStrategy now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
