ICHILDREN

Selects the specified member and all members in the level immediately below it.

Syntax

<ICHILDREN mbrName

Parameters

mbrName

Dimension or member name of the parent

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.

  • ICHILDREN lists members in their defined order, according to the database outline. The parent, which is the member specified as the parameter in the ICHILDREN command, is listed last.

Example

<ICHILDREN Year

Selects members Qtr1, Qtr2, Qtr3, Qtr4, and Year, in that order.

<ICHILDREN Qtr1

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