Essbase @RDESCENDANTS

Returns all descendants of the specified member, or those down to the
specified generation or level, including shared members. 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.

In the absence of shared members, @RDESCENDANTS and @DESCENDANTS return the same result.

Syntax

@RDESCENDANTS (mbrName [, genLevNum| genLevName])
Parameter Description
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

  • The order of members in the result list is important to consider
    when you use the @RDESCENDANTS member set function with certain forecasting
    and statistical functions. Essbase generates the list
    of members in the following sequence: If a shared member is encountered, the
    above steps are repeated on the member being shared.

    1. The specified member
    2. The nearest descendant of the member
    3. The next nearest descendant of the member, and so on.
  • You can use @IRDESCENDANTS to include the specified member in the member list.

Example

Example 1

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

Example 2

@RDESCENDANTS(Profit)

returns Margin, Sales, COGS,
Total Expenses, Marketing, Payroll, and Misc (in that order) and is identical
to @DESCENDANTS(Profit).

See Also

  • @DESCENDANTS
  • @IRDESCENDANTS
  • @IDESCENDANTS
  • @ISDESC
  • @ANCESTORS
  • @CHILDREN
  • @SIBLINGS