Drills up the members of a set that are below a specified level.
DrillupLevel ( set [,layer ])
set | |
layer |
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.
The following example
DrillupLevel ( {[South], [California], [Oregon], [Central], [New York], [West], [Florida]}, [Market].Region )
returns the set:
{ South, Central, West }
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 |