ReferenceLevelVisualTotalsMode

Description Specifies whether to use visual or non-visual totals for marginal and incremental measures

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.

note

In each case the capital charge is determined at the ReferenceLevel.

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.