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

The LEAVES flag is used in conjunction with a depth number and is in-
tended for use with ragged and parent-child hierarchies. If a depth num-
ber is specified without LEAVES, then only members that are at that
depth are returned. If a depth number is specified with LEAVES, then any
leaf members encountered up to that depth are retained. In Analysis Ser-
vices, you can request leaf-level members regardless of their depth by
leaving the depth argument empty. The following would perform that:
Descendants (
[Accounts].CurrentMember,
, /* empty */
LEAVES
)
In Essbase, you don't need to use LEAVES, since you can request leaf-
level members by referring to the dimension's level 0 (remember that in
Essbase, levels refer to heights while generations refer to depths). The
following would retrieve leaf-level members in Essbase:
Descendants (
[Accounts].CurrentMember,
[Accounts].Levels (0)
/* LEAVES is optional at this point */
)
If no flag is specified, the default behavior is SELF.
See also: Ancestor (), Ancestors (), Ascendants (), .Children
Hierarchy .Dimension Returns: dimension Extension: AS2005, AS2000
This function returns the dimension that the hierarchy is in. Because Mi-
crosoft Analysis Services 2000 and, to some degree, 2005 semantically
treat different hierarchies as different dimensions, this function is essen-
tially a "no-op" in those products.
Level .Dimension Returns: dimension Extension: AS2005, AS2000
The function returns the dimension that contains Level.
Member .Dimension Returns: dimension Extension: AS2005, AS2000