Create offline cube files (.cub) with OlapCube. Download Now!


table of contents

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