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>}.