DrillupByLayer

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

Syntax

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.

Note

DrillupLevel can be used as a synonym for DrillupByLayer.

Examples

These examples focus on the following hierarchy from the Sample Basic outline:

Example 1

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

Example 2

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