MDX Compatibility Property

MDX Compatibility Property

SQL Server 2000

MDX Compatibility Property

This property determines how missing members in the hierarchy are treated in ragged and unbalanced hierarchies.

Property Name

MDX Compatibility

Property ID



This property determines how placeholder members in a ragged or unbalanced hierarchy are treated. The following table describes possible values for this property.

Value Description
0 Default. For compatibility with earlier versions, this is the same as Value 1. The meaning of this default value is subject to change in future versions.
1 Default value. Placeholder members are exposed.
2 Placeholder members are not exposed.

This property overrides the following registry setting:


See Also

Ragged Hierarchies

© 2016 Microsoft