Grouping data together – Custom Groups and Consolidations

When new data is needed on the reporting layer, for example a new Region or a new Product Category, it would need to be fed from the source systems to the database. Then, MicroStrategy can execute a query to report it. However, in some scenarios, due to time constraints or because of a very specific and customized requirement, you might want to group the data in a report to create sets, bands, quartiles, or simply to combine Attribute elements without having to modify the database. We will explore two objects that serve this purpose: Custom Groups and Consolidations.

The following is a quick reference table for a MicroStrategy Custom Group:

A Custom Group is an Application Object ...

Get MicroStrategy Quick Start Guide 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.