Intrinsic Dimension and Level Member Properties
All dimensions and levels support a list of intrinsic member properties, displayed in the following table. These member properties are used in the context of a specific dimension or level, and supply values for each member of the specified dimension or level. For example, specifying the following statement in a Multidimensional Expressions (MDX) query:
[Sales].Name
returns the names of each referenced member of the [Sales] dimension.
Property | Description |
---|---|
ID | The internally maintained ID for the member |
Key | The value stored in the MEMBER_KEY column of the MEMBERS schema rowset for the member |
Name | The name of the member |
Dimension member properties are preceded by the name of the dimension to which the property applies. The following example demonstrates the appropriate syntax:
DIMENSION PROPERTIES «Dimension».ID
Level member properties can be preceded with the level name or, for additional specification, the dimension and level name, as shown here:
DIMENSION PROPERTIES [«Dimension».]«Level».ID