DrillupLevel (MDX)

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

Reference

MDX Function Reference (MDX)

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release History

17 July 2006

Changed content:
  • Updated syntax and arguments to improve clarity.
  • Added updated examples.