DrillupByLayer

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

Syntax

DrillupByLayer ( set [,layer] )
ParameterDescription

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:

Expanded Measures dimension including children Profit, Inventory, and Ratios. Included is Margin, the child of Profit. Also included are children of Margin: Sales and COGS.

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:

MeasuresProfit
105522105522

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:

MeasuresProfitMargin
105522105522221519