Returns all members of the specified dimension or layer.
dimension.Members | Members ( dimension )
OR
layer.Members | Members ( layer )
dimension
|
A dimension specification. |
layer
|
A layer specification. |
This example focuses on the following part of the Sample Basic outline:
The following expression:
{([Market].members)}
returns the following set, which includes all descendant members of the Market dimension:
{ Market, [New York], Massachusetts, Florida, Connecticut, [New Hampshire], East, California, Oregon, Washington, Utah, Nevada, West, Texas, Oklahoma, Louisiana, [New Mexico], South, Illinois, Ohio, Wisconsin, Missouri, Iowa, Colorado, Central }
The following expression:
{([Market].levels(1).members)}
returns the following set, which includes one level of descendant members of the Market dimension:
{East, West, South, Central}
The following query assumes that level 1 of the Market dimension has an alias of Region
:
Select {( [Market].[Region].members ) } on columns from Sample.Basic
This query returns the following grid:
East | West | South | Central |
---|---|---|---|
24161 | 29861 | 13238 | 38262 |
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |