@IDESCENDANTS

Returns the specified member and either (1) all descendants of the specified member or (2) all descendants down to a specified generation or level. You can use this member set function as a parameter of another function, where that parameter is a list of members.

Syntax

@IDESCENDANTS (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:

@IDESCENDANTS(East)

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

@IDESCENDANTS(Profit)

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

@IDESCENDANTS(Market,2)

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

@IDESCENDANTS(South,-1)

Returns South.

See Also

@DESCENDANTS
@IRDESCENDANTS
@RDESCENDANTS
@ISDESC
@ANCESTORS
@CHILDREN
@SIBLINGS

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