MicroStrategy ONE
Consolidations vs. custom groups
The following table summarizes the similarities and differences between consolidations and custom groups.
|
|
Consolidation |
Custom Group |
|
Structure |
Groupings of attribute elements |
Filters |
|
Usage |
Create a virtual attribute to allow reporting on an attribute that does not exist in the data model |
Apply different filters to different rows of a report |
|
Arithmetic operations (row level math) |
Yes |
No |
|
Site of final calculation |
Analytical Engine |
Warehouse |
|
SQL efficiency |
High |
Low--one pass for each custom group element |
|
Recursive definition |
Yes |
No |
|
Display mode |
Fixed at element level only |
Flexible and expandable |
|
Subtotals |
Yes |
Yes |
|
Example |
Grouping specific months into a seasons consolidation |
Displaying Top 5 Customers, Top 5 Employees, and Top 5 Items on the same report |
For more details, see the Custom Groups and Consolidations chapter of the Advanced Reporting Help.