ReferenceLevelVisualTotalsMode

This context value affects the interpretation of filters for capital allocation (Euler and Pro-Rata) and incremental measures.

When a capital allocation query includes filters, then the filtering is applied as follows:

• With VISUAL TOTALS, filtering is applied to the underlying data before calculating the capital allocation. The capital allocations sum to the capital charge of the filtered data.

• With NON-VISUAL TOTALS, the results are as if the filtering was applied to the result set after calculating the capital allocation. The capital allocations would sum to the capital charge of the unfiltered data, though some are filtered out of the results.

This context value can take three values, each corresponding to a specific mode:

Mode	Description
(default) COMPATIBILITY	Uses the visual or non-visual totals specified in the MDX. For example WHERE-clause for non-visual totals SUBSELECT-clause for visual totals
VISUAL	Forces the use of visual totals.
NON VISUAL	Forces the use of non-visual totals.