Export (0) Print
Expand All
Expand Minimize

DrillupLevel (MDX)

Drills up the members of a set that are below a specified level.


DrillupLevel(Set_Expression [ , Level_Expression ] )

Set_Expression

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

Level_Expression

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

The DrillupLevel function returns a set of members organized hierarchically based on the members included in the specified set. Order is preserved among the members in the specified set.

If a level expression is specified, the DrillupLevel function constructs the set by retrieving only those members that are above the specified level. If a level expression is specified and there is no member of the specified level represented in the specified set, the specified set is returned.

If a level expression is not specified, the function constructs the set by retrieving only those members that are one level higher than the lowest level of the first dimension referenced in the specified set.

Example

The following example returns the set of members from the first set that are above the Subcategory level.

SELECT DrillUpLevel 
  ({[Product].[Product Categories].[All Products]
    ,[Product].[Product Categories].[Subcategory].&[32],
    [Product].[Product Categories].[Product].&[215]},
  [Product].[Product Categories].[Subcategory]
    )
  ON 0
  FROM [Adventure Works]
  WHERE [Measures].[Internet Order Quantity]

Community Additions

ADD
Show:
© 2014 Microsoft