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 |