@DESCENDANTS

Returns all descendants of the specified member, or those down to the specified generation or level. This function excludes the specified member. You can use this member set function as a parameter of another function, where that parameter is a list of members.

Syntax

@DESCENDANTS (mbrName [, genLevNum| genLevName])

mbrName Any valid single member name or member combination, or a function that returns a single member or member combination.
genLevNum Optional. An integer value that defines the absolute generation or level number down to which to select the members. A positive integer defines a generation number. A value of 0 or a negative integer defines a level number.
genLevName Optional. Level name or generation name down to which to select the members.

Notes

Example

In the Sample Basic database:

@DESCENDANTS(East)

returns New York, Massachusetts, Florida, Connecticut, and New Hampshire (in that order).

@DESCENDANTS(Profit)

returns Margin, Sales, COGS, Total Expenses, Marketing, Payroll, and Misc (in that order).

@DESCENDANTS(Market,2)

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

@DESCENDANTS(Diet,0)

returns 100-20, 200-20, and 300-30 (in that order).

See Also

@IDESCENDANTS
@RDESCENDANTS
@IRDESCENDANTS
@ISDESC
@ANCESTORS
@CHILDREN
@SIBLINGS

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