MDX Function and Operator Reference - Professional SQL Server Analysis Services 2005 with MDX - page 1088

Leaves ( dimension ) Returns: set
This function returns a set of the cross-join of the lowest level of all attrib-
ute hierarchies in the dimension. This includes the dimension's key attrib-
ute and all leaf-level attributes. If the dimension is omitted, the leaf level
space is a set for the entire leaf level of the cube (!).
Note that the Leaves () function cannot be used if different measure
groups in scope in the cube use the dimension at different levels of gran-
ularity (including if some are dimensioned by it and some do not). You
can select from a subcube that only includes measures from a suitable
measure group or groups.
While you can use this function in any MDX expression, it is most likely
to be useful as part of specifying subcubes either in an MDX script or in a
query or session subcube.
See also: MeasureGroupMeasures (), Root ()
member .Level Returns: level Standard
This function returns a member's level.
Levels ( string expression ) Returns: level Extension: AS2005, AS2000
This function returns the level whose name is given by string expression.
It is typically used with user-defined functions (UDFs) that return a name.
The string expression can be any expression that results in a level refer-
ence. For example, the string "[Time].[Year]" will result in the year level of
the Time dimension. However, the string "[Time].Levels (1)" in a Time di-
mension where the year level is the first one down from the root level will
also result in the year level. (See the following description for the Dimen-
sion.Levels () function as well.)
Dimension .Levels ( numeric expression ) Returns: level Standard
This function returns the dimension level specified by numeric expres-
sion. Note that in Analysis Services, the number is zero-based, starting
at the root level, while in Essbase the number is one-based starting at
the leaf level.