DrilldownLevelBottom

Analysis Services

Analysis Services

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