Create offline cube files (.cub) with OlapCube. Download Now!

table of contents


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


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


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


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