DrillupLevel

Analysis Services

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