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

Similarly to DrillDownLevel () and DrillDownLevelBottom (), this function
drills down all members in set that are at the specified level , if the level is
provided (or the lowest level of members that are present in the set if
level is not provided). However, instead of returning all children, this func-
tion returns only the top index members or tuples. The set can be of ar-
bitrary dimensionality. The ranking is determined through the numeric ex-
pression , if one is provided, or through the values of cells found in the
default context when the set is evaluated, if the numeric value expression
is left out. Figure A-15 illustrates the behavior of DrillDownLevelTop (). As
with DrillDownLevel (), if a member at level is immediately followed by
one of its children, it will not be drilled down on.
Figure A-15: DrillDownLevelTop ().
If one or more children of a member to be drilled down into immedi-
ately follows a parent in set, then that parent will not be drilled down
into.
DrillDownMember ( set1 , set2 [, RECURSIVE]) Returns: set Standard
This function returns a set that is formed by drilling down one level
on each member in set1 that is present in set2. Set1 can be of arbit-
rary dimensionality; set2 must be of only one dimension. The ability
of set1 to consist of more than one dimension is an extension to the
OLE DB for OLAP specification.
If set1 contains tuples, this function will return a set that is formed by
drilling down each tuple in set1 that has a matching member from
set2 in it. If RECURSIVE is not specified, then only one pass