Strategy ONE

MDX Remember Measure Dimension Name

MDX Remember Measure Dimension Name 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 defines how the name of the measure dimension is determined for an MDX cube source. You can choose from the following settings:

  • Do not remember the name of the measure dimension: The MDX cube source is not analyzed to determine the name of the measure dimension. Since most MDX cube sources use [Measures] as the measure dimension name and MicroStrategy recognizes this default name, this option is recommended for most MDX cube sources.
  • Remember the name of the measure dimension: The MDX cube source is analyzed to determine the name of the measure dimension. The name returned is then used later when querying the MDX cube source. This option can be used when an MDX cube source does not use [Measures] as the measure dimension name, which is the default used for most MDX cube sources. Essbase is the MDX cube source that most commonly uses a measure dimension name other than [Measures].
  • Read the name of the measure dimension from the "Name of Measure Dimension" VLDB setting: The measure dimension name defined using the Name of Measure Dimension VLDB property (see MDX Remember Measure Dimension Name) is used as the measure dimension name. You can use this option if the MDX cube source does not use [Measures] as the measure dimension name, and you know what alternative name is used for the measure dimension.

Levels at Which You Can Set This

Database instance only