MicroStrategy ONE
Subtotal Dimensionality Aware
MicroStrategy 7i (7.2.x and later) has the ability to detect the level of a metric and subtotal it accordingly. The Subtotal Dimensionality Aware property allows you to choose between the 7.1 and earlier subtotaling behavior (FALSE) and the 7.2.x and later subtotaling behavior (TRUE). MicroStrategy recommends that you set this property to TRUE.
If this property is set to True, and a report contains a metric that is calculated at a higher level than the report level, the subtotal of the metric is calculated based on the metric's level. For example, a report at the Quarter level containing a yearly sales metric shows the yearly sales as the subtotal instead of summing the rows on the report.
Levels at Which You Can Set This
Project, report, template, and metric
Example
Quarterly Dollar Sales metric is defined as
Sum(Revenue) Dimensionality = Quarter
Yearly Dollar Sales metric is defined as
Sum(Revenue) Dimensionality = Year
| Year | Quarter | Quarterly Dollar Sales | Yearly Dollar Sales |
|
2022 |
1 |
100 |
600 |
|
2022 |
2 |
200 |
600 |
|
2022 |
3 |
100 |
600 |
|
2022 |
4 |
200 |
600 |
|
|
Grand Total |
600 |
2400 or 600 depending on the setting (see below) |
If Subtotal Dimensionality Aware is Set to FALSE
The quarterly subtotal is calculated as 600, that is, a total of the Quarterly Dollar Sales values. The yearly subtotal is calculated as 2400, the total of the Yearly Dollar Sales values. This is how MicroStrategy 7.1 calculates the subtotal.
If Subtotal Dimensionality Aware is Set to TRUE
The quarterly subtotal is still 600. Intelligence Server is aware of the level of the Yearly Dollar Sales metric, so rather than adding the column values, it correctly calculates the Yearly Dollar Sales total as 600.