Members

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: