Returns all members of the specified dimension or layer.
Syntax
dimension.Members | Members ( dimension )
layer.Members | Members ( layer )
Example
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 |