Returns all descendants of the specified member, or those down to the specified generation or level, including shared members.
@RDESCENDANTS (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. |
This function returns all descendants of the specified member, or those down to the specified generation or level. This function excludes the specified member. If one or more of the descendants are shared, the result also includes either all descendants of each member being shared or descendants down to the 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.
In the absence of shared members, @RDESCENDANTS and @DESCENDANTS return the same result.
Assume a variation of the Sample Basic database such that the Product dimension includes the following members:
Product 100 100-10 100-20 100-30 200 200-10 200-20 200-30 200-40 Diet 100 (Shared Member) 200 (Shared Member)
Diet has two children "100" and "200". The members "100" and "200" are shared members.
@RDESCENDANTS(Diet)
returns the members: 100, 100-10, 100-20, 100-30, 200, 200-10, 200-20, 200-30, 200-40 (in that order).
@RDESCENDANTS(Profit)
returns Margin, Sales, COGS, Total Expenses, Marketing, Payroll, and Misc (in that order) and is identical to @DESCENDANTS(Profit).
@DESCENDANTS
@IRDESCENDANTS
@IDESCENDANTS
@ISDESC
@ANCESTORS
@CHILDREN
@SIBLINGS
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |