@CHILDREN

The @CHILDREN calculation function for Essbase returns children of a member.

This function 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)

Parameters

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

Notes

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

Example

In the Sample Basic cube:

@CHILDREN(Market)

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

@CHILDREN(Margin)

returns Sales and COGS (in that order).