Share via

Leveling Rules for MDX Statement

  • Article

  1. Support for WITH clause is optional. Consumers can check the value of the property MDPROP_MDX_FORMULAS to see whether a provider supports this feature.

  2. Support for <set> in <slicer_specification> is optional. Consumers can check the value of the property MDPROP_MDX_SLICER to see whether a provider supports this feature.

  3. Support for more than one cube name in <cube_specification> is optional. Support for having no cube name in the FROM clause (that is, the cube is implicitly defined by the axis and slicer dimensions) is also optional. Consumers can check the value of the property MDPROP_MDX_JOINCUBES to see whether a provider supports this feature.

  4. The axis names CHAPTERS and SECTIONS are optional. Consumers can check the value of the property MDPROP_AXES to see whether a provider supports this feature.

  5. Support for <index> > 2 in the AXIS(<index>) function is optional. Consumers can check the value of the property MDPROP_AXES to see whether a provider supports this feature.

  6. Support for <create_formula_statement> and <drop_formula_statement> is optional. Consumers can check the value of the property MDPROP_MDX_FORMULAS to see whether a provider supports this feature.

  7. If a provider supports <create_formula_statement>, support for a <scope> of GLOBAL is optional. Consumers can check the value of the property MDPROP_MDX_FORMULAS to see whether a provider supports this feature.