CHILDREN

The Essbase Report Writer CHILDREN command selects all members in the level immediately below the specified member, excluding the specified member.

Syntax

<CHILDREN mbrName

Parameters

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 outline order. The parent, specified by mbrName, is not included.
The ICHILDREN command includes the specified member.

Example

<CHILDREN Year

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

<CHILD Qtr1

Selects members Jan, Feb, and Mar, in that order.