Export (0) Print
Expand All
Avg
IIf
Lag
Max
Min
Mtd
Qtd
Sum
Var
Wtd
Ytd
Expand Minimize

DrilldownMemberBottom (MDX)

Updated: 17 July 2006

Drills down the members in a specified set that are present in a second specified set, limiting the result set to a specified number of members. Alternatively, this function also drills down on a set of tuples.


DrilldownMemberBottom(Set_Expression1, Set_Expression2, Count [ , [ Numeric_Expression ][ , RECURSIVE ] ] )

Set_Expression1

A valid Multidimensional Expressions (MDX) expression that returns a set.

Set_Expression2

A valid Multidimensional Expressions (MDX) expression that returns a set.

Count

A valid numeric expression that specifies the number of tuples to be returned.

Numeric_Expression

A valid numeric expression that is typically a Multidimensional Expressions (MDX) expression of cell coordinates that return a number.

If a numeric expression is specified, the DrilldownMemberBottom function sorts, in ascending order, the children of each member in the first set, according to the value of the numeric expression, as evaluated over the set of child members. If a numeric expression is not specified, the function sorts, in ascending order, the children of each member in the first set according to the values of the cells represented by the set of child members, as determined by the query context.

After sorting, the DrilldownMemberBottom function returns a set that contains the parent members and the number of child members, specified in Count, with the lowest value and are contained by both sets.

If RECURSIVE is specified, the function sorts the first set as described previously, then recursively compares the members of the first set, as organized in a hierarchy, against the second set. The function retrieves the bottommost number of children for each member in the first set that is also present in the second set.

The first set can contain tuples instead of members. Tuple drilldown is an extension of OLE DB, and returns a set of tuples instead of members.

The DrilldownMemberBottom function is similar to the DrilldownMember function, but instead of including all children for each member in the first set that is also present in the second set, the DrilldownMemberBottom function returns the bottommost number of child members for each member.

Example

The following example drills down into the clothing category to return the three subcategories of clothing with the bottom quantity of orders shipped.

SELECT DrilldownMemberBottom 
  ({[Product].[Product Categories].[All Products],
     [Product].[Product Categories].[Category].Bikes,
     [Product].[Product Categories].[Category].Clothing}
   ,
  {[Product].[Product Categories].[Category].Clothing},
  3,
  [Measures].[Measures].[Reseller Order Quantity]
  )
  ON 0
  FROM [Adventure Works]
  WHERE [Measures].[Internet Order Quantity]

Release History

17 July 2006

Changed content:
  • Updated syntax and arguments to improve clarity.
  • Added updated examples.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft