Drills down members of a set that are at a specified layer.
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. |
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.
DrilldownLevel
can be used as a synonym for DrilldownByLayer
.
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 |