@ICHILDREN

The @ICHILDREN calculation function for Essbase returns a member and all its children.

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

Syntax

@ICHILDREN (mbrName)

Parameters

mbrName: Any valid single member name, or a function that returns a single member.

Notes

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 this function with certain forecasting and statistical functions.

Example

In the Sample Basic database:

@ICHILDREN(Market)

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

@ICHILDREN(Margin)

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