Members

The MDX Members function returns all members of the specified Essbase dimension or layer.

Syntax

dimension.Members | Members ( dimension )

layer.Members | Members ( layer )

Parameters

dimension

A dimension specification.

layer

A layer specification.

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:

Table 4-113 Output Grid from MDX Example

East	West	South	Central
24161	29861	13238	38262