MDX has Measure Values in Other Hierarchies

MDX Has Measure Values In Other Hierarchies is an advanced property that is hidden by default. For information on how to display this property, see Viewing and Changing Advanced VLDB Properties.

This VLDB property determines how null values are identified if you use the MDX Non Empty Optimization VLDB property (see MDX has Measure Values in Other Hierarchies) to ignore null values coming from MDX cube sources.

If you define the MDX Non Empty Optimization VLDB property as No non-empty optimization, then this VLDB property has no effect on how null values are ignored. If you use any other option for the MDX Non Empty Optimization VLDB property, you can choose from the following settings:

• Only include the affected hierarchy in the "has measure values" set definition: Only a single hierarchy on the MDX cube report is considered when identifying and ignoring null values. This requires fewer resources to determine the null values, but some values can be mistakenly identified as null values in scenarios such as using calculated members in an MDX cube source.
• Include all template hierarchies in the "has measure values" set definition: All hierarchies that are part of an MDX cube report are considered when identifying and ignoring null values. This can help to ensure that some values are not lost when MicroStrategy ignores null values from the MDX cube source. Including all hierarchies to identify null values can require additional system resources and time to complete.

Levels at Which You Can Set This

Database instance and report