Drills up the members of a set that are below a specified layer.
Syntax
DrillupByLayer ( set [,layer] )
Parameter | Description |
---|---|
The set in which the drill-up should occur. | |
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. |
Notes
DrillupLevel can be used as a synonym for DrillupByLayer.
Example
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 |