Returns a set of all child members of the specified member.
Syntax
member.Children
Children ( member )
Parameter | Description |
---|---|
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:
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:
(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 |