1. Calculation and Query Reference for Oracle Essbase
  2. MDX
  3. MDX Function List
  4. Children

Children

The MDX Children function for Essbase returns a set of all child members of the specified member.

Syntax

member.Children
Children ( member )

Parameters

member

A member specification.

Notes

If the input member does not have any children (is a level-0 member), this function returns an emtpy set.

Example

This example uses the following parts of the Sample Basic outline:


Expanded West dimension from Sample Basic, with states as children. Expanded Diet dimension with children 100-20, 200-20, and 300-30.

The following expression

([West].children)

returns the set:

{ [California], [Oregon], [Washington], [Utah], [Nevada] }

And the following expression

([Diet].children)

returns the set:

{ [100-20], [200-20], [300-30] }

Therefore, the following query

SELECT
  {([West].children)}
ON COLUMNS,
  {([Diet].children)}
ON ROWS
FROM Sample.Basic

returns the grid:

Table 4-45 Output Grid from MDX Example

(axis) California Oregon Washington Utah Nevada
100-20 -1587 338 231 398 86
200-20 2685 1086 579 496 167
300-30 1328 288 1217 413 362