Children

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

Syntax

member.Children

Children ( 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: