OrderingMemberProperty (Level Interface)
Note
This feature will be removed in the next version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.
The OrderingMemberProperty of the Level interface specifies the member property that is used to determine the ordering of level members.
Applies To:clsAggregationLevel, clsCubeLevel, clsDatabaseLevel, clsPartitionLevel
Data Type
String
Access
Access depends on the value of the ClassType property of the object.
| Class type | Access |
|---|---|
clsDatabaseLevel |
R/W* |
clsCubeLevel |
R |
clsPartitionLevel |
R |
clsAggregationLevel |
R |
* Read-only for levels with an Ordering of orderKey or orderName.
Remarks
This property allows the level to be ordered by a member property instead of by name or by key. To order by member property, set the value of the Ordering property to orderMemberProperty, and then set the value of the OrderMemberProperty property to the name of the member property. If the Ordering property of the object is set to orderName or orderKey, this property is read-only, and the value of this property is set to "Name" or "Key", respectively.
See Also
Reference
Level Interface
Ordering (Level Interface)
OrderTypes