Drills up the members of a set that are below a specified layer.
DrillupByLayer ( set [,layer] )
set | The set in which the drill-up should occur. |
layer | The layer of the members that should be drilled up. If omitted, the set is drilled up to the second lowest level found in the set. |
DrillupLevel
can be used as a synonym for DrillupByLayer
.
These examples focus on the following hierarchy from the Sample Basic outline:
The following query drills up the members of set to the second generation of the Measures dimension:
SELECT DrillupByLayer ( {[Measures],[Profit], [Margin], [Sales], [COGS] }, Generations([Measures], 2) ) ON COLUMNS FROM Sample.Basic
This query returns the grid:
Measures | Profit |
---|---|
105522 | 105522 |
With no layer specified, the following query drills up the members of set to the second lowest level found in set:
SELECT DrillupByLayer ( {[Measures],[Profit], [Margin], [Sales], [COGS] } ) ON COLUMNS FROM Sample.Basic
This query returns the grid:
Measures | Profit | Margin |
---|---|---|
105522 | 105522 | 221519 |
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |