DrilldownByLayer

Drills down members of a set that are at a specified layer.

Syntax

DrilldownByLayer ( set [, layer | index ] )

set The set in which the drilldown should occur.
layer The layer of the members that should be drilled down.
index A number of hierarchical steps representing the location of members that should be drilled down.

Description

This function returns the members of set to one level below the optionally specified layer (or index number of the level). If layer (or index) is omitted, the lowest level of set is returned. Members are returned in their hierarchical order as represented in the database outline.

Note

DrilldownLevel can be used as a synonym for DrilldownByLayer.

Example

The following query

SELECT
DrilldownByLayer ( 
 {([Product],[California]), ([Product],[Oregon]),
  ([Product],[New York]), ([Product],[South]),
  ([Product],[Washington])}, [Market].[Region]
 ) 
ON COLUMNS
FROM Sample.Basic

returns the grid:

Product Product Product Product Product Product Product Product Product
California Oregon New York South Texas Oklahoma Louisiana New Mexico Washington
12964 5062 8202 13238 6425 3491 2992 330 4641

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com