DrilldownLevelTop (MDX)

Drills down the topmost members of a set, at a specified level, to one level below.

Syntax

DrilldownLevelTop(Set_Expression, Count [ , [ Level_Expression ][ ,Numeric_Expression ] ] )

Arguments

  • Set_Expression
    A valid Multidimensional Expressions (MDX) expression that returns a set.
  • Count
    A valid numeric expression that specifies the number of tuples to be returned.
  • Level_Expression
    A valid Multidimensional Expressions (MDX) expression that returns a level.
  • Numeric_Expression
    A valid numeric expression that is typically a Multidimensional Expressions (MDX) expression of cell coordinates that return a number.

Remarks

If a numeric expression is specified, the DrilldownLevelTop function sorts, in descending order, the children of each member in the specified 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 descending order, the children of each member in the specified set according to the values of the cells represented by the set of child members, as determined by the query context.

After sorting, the DrilldownLevelTop function returns a set that contains the parent members and the number of child members, specified in Count, with the highest value.

The DrilldownLevelTop function is similar to the DrilldownLevel function, but instead of including all children for each member at the specified level, the DrilldownLevelTop function returns the topmost number of child members.

Example

The following example returns the top three children of the Product Category level, based on the default measure.

SELECT DrilldownLevelTop 
   ([Product].[Product Categories].children,
   3,
   [Product].[Product Categories].[Category])
   ON 0
   FROM [Adventure Works]

See Also

Reference

DrilldownLevel (MDX)
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.