Returns a set of all child members of the specified member.
member.Children
OR
Children ( member )
| member | A member specification. |
This function returns all members that are children of the specified member.
If the input member does not have any children (is a level-0 member), this function returns an emtpy set.
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 |