DrillupLevel (MDX)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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

Syntax


DrillupLevel(Set_Expression [ , Level_Expression ] )  

Arguments

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

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

Remarks

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]  

See Also

MDX Function Reference (MDX)