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 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 reference level.
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 exampleWHERE-clause for non-visual totalsSUBSELECT-clause for visual totals