DrilldownLevelBottom (MDX)
Drills down the bottommost members of a set, at a specified level, to one level below.
Syntax
DrilldownLevelBottom(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 DrilldownLevelBottom function sorts, in ascending order, the children of each member in the specified set, according to the specified value, 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 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 DrilldownLevelBottom function returns a set that contains the parent members and the number of child members, specified in Count, with the lowest value.
The DrilldownLevelBottom function is similar to the DrilldownLevel function, but instead of including all children for each member at the specified level, the DrilldownLevelBottom function returns the bottom-most number of child members.
Example
The following example returns the bottom three children of the Product Category level, based on the default measure.
SELECT DrilldownLevelBottom
([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 |
|