Children

Returns a set of all child members of the specified member.

Syntax

member.Children

OR

Children ( member )

member A member specification.

Description

This function returns all members that are children of the specified member.

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:

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:

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

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com