@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)

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

Description

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.

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, which includes the specified member.
@ISCHILD
@ANCESTORS
@DESCENDANTS
@SIBLINGS

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com