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 |