Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
DrilldownLevelBottom

DrilldownLevelBottom

SQL Server 2000

DrilldownLevelBottom

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

Syntax

DrilldownLevelBottom(«Set», «Count»[, [«Level»][, «Numeric Expression»]])

Remarks

This function is similar to the DrilldownLevel function, but instead of including all children for each member at the specified «Level», only the bottom «Count» of children is returned, based on «Numeric Expression».

Example

Assuming Oregon and Washington had the lowest sales, the following example returns the set {USA, Oregon, Washington}:

DrilldownLevelBottom({[Customers Location].USA},2,,[Unit Sales])

The expression

DrilldownLevelBottom({[Customers Location].[Country].Members},2,,[Unit Sales])

returns the set

{Canada, <bottom two provinces in Canada>, 
Mexico, <bottom two states in Mexico>, ..., 
USA, <bottom two states in USA>}.

See Also

DrilldownLevel

Show:
© 2015 Microsoft