DrillupLevel

Drills up the members of a set that are below a specified level.

Syntax

DrillupLevel ( set [,layer ])

set
layer

Description

If layer is not specified, it is assumed to be the level immediately above the level of the lowest level member in set. The drillup is carried out by removing all members in set that are below layer.

Example

Example 1

The following example

DrillupLevel ( 
  {[South], [California], [Oregon], 
   [Central], [New York], [West],
   [Florida]}, 
   [Market].Region
)

returns the set:

{ South, Central, West }

Example 2

The following example

DrillupLevel ( 
  {
   [South], [California], [Oregon], 
   [Central], [New York], [West],
   [Florida] 
  }
)

returns the same set as Example 1, because the lowest level represented in the input set is States.

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com