Subtotal Dimensionality Aware

The Subtotal Dimensionality Aware setting enables subtotaling based on the dimensionality of a metric, also known as its level. How it works depends on another VLDB property, Query Population Dimensionality Aware, which handles backwards compatibility with MicroStrategy 7.1. These settings work together as listed in the following table:

If Query Population Is:	Then Subtotal Is:
TRUE	TRUE or FALSE
FALSE	Ignored, meaning that subtotals are never aware of dimensionality

The default setting for the Subtotal Dimensionality Aware property is TRUE, so subtotals depend on the metric's level. If you must subtotal without using the level of the metric, set this property to FALSE.

This property is found in the Analytical Engine folder of the VLDB Properties (Metric) dialog box. The options for this property are:

• FALSE, which means that subtotals do not take into account the level/dimensionality of the metric
• TRUE, which means that subtotaling is aware of metric level/dimensionality
• Use default inherited value

For example, the Quarterly Revenue metric is defined as Sum(Revenue) Dimensionality = Quarter, and the Yearly Revenue metric is defined as Sum(Revenue) Dimensionality = Year.

Year	Quarter	Quarterly Revenue	Yearly Revenue
1	1	$100	$600
1	2	$200	$600
1	3	$100	$600
1	4	$200	$600

If Subtotal Dimensionality Aware is set to FALSE, the quarterly subtotal is calculated as $600, the total of the Quarterly Revenue values. The yearly subtotal is calculated as $2400, the total of the Yearly Revenue values. This is how MicroStrategy 7.1 calculated the subtotal.

If Subtotal Dimensionality Aware is set to TRUE, the quarterly subtotal is still $600. MicroStrategy is aware of the level of the Yearly Revenue metric, so rather than simply adding the column values, it calculates the total as $600.