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

limiting the scope within the dimensions, when you are taking the distinct
count at aggregate members in one or more of the dimensions, or when
one or more dimensions involve a calculated member. Remember that
the DistinctCount aggregation is handled to some degree by the server
during cube aggregation, while this function is calculated at client query
time.
See also: Distinct (), Count (), .Count
DrillDownLevel ( set [, level ]) Returns: set Standard
This function returns a set resulting from a particular drill-down operation
performed by the function. Set can be of arbitrary dimensionality. When
the level argument is specified, all members or tuples in set that are in
level are drilled down into the next lowest level (if there is one). When the
level argument is not specified, only those members or tuples that are at
the lowest level in the first dimension of the set are drilled down into, and
they are drilled down into the next lower level. The behavior of
DrillDownLevel () is shown in Figure A-13 . All children are inserted imme-
diately after their parents; otherwise, the order is preserved. If level is
specified, but there is no member at level in the set , then the given set is
returned without modification.