<CHILDREN

Command

The CHILDREN command selects all members in the level immediately below the specified member as defined in the database outline.

Syntax

<CHILDREN mbrName

mbrName Dimension or member name of the parent

Description

This command does not select the specified member.

Example

<CHILDREN Year

Which selects members Qtr1, Qtr2, Qtr3, and Qtr4, in that order (see the Notes for this command).

<CHILD Qtr1

Which selects members Jan, Feb, and Mar, in that order.

Notes

If member names contain spaces (for example, Cost of Goods Sold) or consist of numbers (for example, 100-10), they must be enclosed in double quotes.
CHILDREN lists members in their defined order, according to the Database Outline. The parent, which is the member specified as the parameter in the CHILDREN command, is not included.
The ICHILDREN command includes the specified member.

See Also

DESCENDANTS
ICHILDREN
IDESCENDANTS