DrillupByLayer

The MDX DrillupByLayer function for Essbase drills up the members of a set that are below a specified layer.

Syntax

DrillupByLayer ( set [,layer] )

Parameters

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.

Notes

DrillupLevel can be used as a synonym for DrillupByLayer.

Example

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:

Table 4-58 Output Grid from MDX Example

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:

Table 4-59 Output Grid from MDX Example

Measures	Profit	Margin
105522	105522	221519