Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

MDX Object Qualification Property

SQL Server 2000

MDX Object Qualification Property

This property provides a bitmask that specifies how multidimensional schema object names are qualified in Multidimensional Expressions (MDX) expressions.

Property Name

MDX Object Qualification

Property ID

MDPROP_OBJQUALIFICATION

Remarks

This read-only property determines how a provider qualifies object names.

The following table describes the function of each bit in this property.

Bit Description
MDPROPVAL_MOQ_DATASOURCE Cubes are qualified by data source name.
MDPROPVAL_MCQ_CATALOG Cubes are qualified by catalog name.
MDPROPVAL_MCQ_SCHEMA Cubes are qualified by schema name. If the MDPROPVAL_MOQ_DATASOURCEMDPROPVAL_MCQ_CATALOG bits are not set, the provider does not support cube qualification.
MDPROPVAL_MOQ_CUBE_DIM Dimensions are qualified by cube name.
MDPROPVAL_MOQ_DIM_HIER Hierarchies are qualified by dimension name.
MDPROPVAL_MOQ_DIMHIER_LEVEL Levels are qualified by dimension name and/or hierarchy name. This property applies only if the provider supports named levels. The MDPROP_NAMED_LEVELS bit of this property indicates whether named levels are supported.
MDPROP_NAMED_LEVELS This bit is set if named levels are not supported.
MDPROPVAL_MOQ_DIMHIER_MEMBER Members are qualified by dimension name and/or hierarchy name.
MDPROPVAL_MOQ_LEVEL_MEMBER Members are qualified by level name.
MDPROPVAL_MOQ_MEMBER_MEMBER Members are qualified by ancestor name(s).

PivotTable® Service and Microsoft® SQL Server™ 2000 Analysis Services set the following bitmask for this property:

MDPROPVAL_MOQ_DIM_HIER
| MDPROPVAL_MOQ_DIMHIER_LEVEL
| MDPROPVAL_MOQ_DIMHIER_MEMBER
| MDPROPVAL_MOQ_LEVEL_MEMBER
| MDPROPVAL_MOQ_MEMBER_MEMBER

The client application cannot change the value of this property.

Show:
© 2015 Microsoft