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

through set1 is performed, matching each member or tuple with
each member in set2. If RECURSIVE is specified, then the set res-
ulting from the first pass is again matched with each member in set2 ,
and so on until no more members in the set being constructed are
found in set2. Figure A-16 illustrates the behavior of DrillDownMem-
ber ().
Figure A-16: DrillDownMember ().
If one or more children of a member to be drilled down into im-
mediately follows a parent in set, then that parent will not be
drilled down into.
See also: DrillUpMember ()
DrillDownMemberBottom ( set1 , set2 , index [, numeric expression ][,
RECURSIVE]) Returns: set