Export (0) Print
Expand All

DrilldownLevelTop

SQL Server 2000

DrilldownLevelTop

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

Syntax

DrilldownLevelTop(«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 top «Count» of children is returned, based on «Numeric Expression».

Example

Assuming California and New York had the highest sales, the following example returns the set {USA, California, New York}:

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

The expression

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

returns the set

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

See Also

DrilldownLevel

Show:
© 2015 Microsoft