Analysis Services
DrillupLevel
Drills up the members of a set that are below a specified level.
Syntax
DrillupLevel(«Set»[, «Level»])
Remarks
If «Level» is not specified, it is assumed to be the level immediately above the level of the lowest level member in «Set».
Example
This example
DrillUpLevel({USA, California, [Los Angeles], Washington, Seattle, Canada, [British Columbia]})
returns the set
{USA, California, Washington, Canada, [British Columbia]}
and this example
DrillUpLevel({USA, California, [Los Angeles], Washington, Seattle, Canada, [British Columbia]},[Store Country])
returns the set
{USA, Canada }.