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.
@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. |
@DESCENDANTS(100)
,
Analytic Services returns 100-10, 100-20, 100-30 (in that order). This order is
important to consider when you use the @DESCENDANTS member set
function with certain forecasting and statistical functions.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).
@IDESCENDANTS
@RDESCENDANTS
@IRDESCENDANTS
@ISDESC
@ANCESTORS
@CHILDREN
@SIBLINGS
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |