Essbase @CHILDREN

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

Syntax

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

Notes

Essbase sorts the child members in ascending
order. Using Sample Basic as an example, if you specify 100 for mbrName, Essbase returns 100-10,
100-20, 100-30 (in that order). This order is important to consider when you
use the @CHILDREN member set function with certain forecasting and statistical
functions.

Example

In the Sample Basic database:

@CHILDREN(Market)

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

@CHILDREN(Margin)

returns Sales and COGS (in
that order).

See Also

  • @ICHILDREN
  • @ISCHILD
  • @ANCESTORS
  • @DESCENDANTS
  • @SIBLINGS