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.
@CHILDREN (mbrName)
mbrName | Any valid single member name or member combination, or a function that returns a single member or member combination. |
Analytic Services sorts the child members in ascending order. Using Sample Basic as an example, if you specify 100 for mbrName, Analytic Services 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.
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).
@ICHILDREN, which includes the specified member.
@ISCHILD
@ANCESTORS
@DESCENDANTS
@SIBLINGS
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |