Returns the specified member and all of its children. This member set
function can be used as a parameter of another function, where that parameter
is a list of members.


@ICHILDREN (mbrName)
Parameter Description
mbrName Any valid single member name or member combination, or a function that
returns a single member or member combination.


Essbase sorts the generated list of members starting
with the specified member, followed by its children in ascending order. Using
Sample Basic as an example, if you specify 100 for mbrName, Essbase returns 100, 100-10, 100-20, 100-30 (in that order).
This order is important to consider when you use the @ICHILDREN member set
function with certain forecasting and statistical functions.


In the Sample Basic database:


Returns Market, East, West,
South, and Central (in that order).


Returns Margin, Sales, and
COGS (in that order).

See Also