Adds the descendants of mbrName to the report, excluding mbrName.
Adding the descendants of the top of the dimension adds all the members in the dimension to the report, except the dimension top.
When a generation or level name is provided, this command returns all descendants at (or up to) the specified generation or level below mbrName.
Syntax
<DESCENDANTS mbrName
When used as an extraction command in conjunction with the < LINK command, the syntax is:
<DESCENDANTS (mbrName [, gen/levelName [, AT|UPTO]])
Parameter | Description |
---|---|
mbrName | Name of parent of descendants. |
gen/levelName | Optional. Generation or level name. |
AT | Optional. Keyword indicating that all descendants at the specified generation or level should be returned. If AT or UPTO are omitted, this behavior is the default. |
UPTO | Optional. Keyword indicating that all descendants between the root member and up to the specified generation or level should be returned. The root member is also returned. |
Notes
The IDESCENDANTS command includes the specified member.
The DESCENDANTS command, when used with UPTO keyword, includes the specified member.
Syntax specifying generation or level is available only when this command is used as an extraction command in conjunction with the <LINK command.
Example
<DESCENDANTS Year
Selects members Jan, Feb, Mar, Q1, Apr, May, June, Q2, Jul, Aug, Sep, Q3, Oct, Nov, Dec, Q4.
<LINK(<DESCENDANTS(Market,"Lev0,Market")) OR <LINK(<DESCENDANTS(Market,State)) !
This example produces the following report:
New York #Missing Massachusetts #Missing Florida #Missing Connecticut #Missing New Hampshire #Missing California #Missing Oregon #Missing Washington #Missing Utah #Missing Nevada #Missing Texas #Missing Oklahoma #Missing Louisiana #Missing New Mexico #Missing Illinois #Missing Ohio #Missing Wisconsin #Missing Missouri #Missing Iowa #Missing Colorado #Missing
<LINK(<DESCENDANTS(Market,"Lev0,Market",UPTO)) OR <LINK(<DESCENDANTS(Market,State,UPTO)) !
This example produces the following report:
Market #Missing New York #Missing Massachusetts #Missing Florida #Missing Connecticut #Missing New Hampshire #Missing East #Missing California #Missing Oregon #Missing Washington #Missing Utah #Missing Nevada #Missing West #Missing Texas #Missing Oklahoma #Missing Louisiana #Missing New Mexico #Missing South #Missing Illinois #Missing Ohio #Missing Wisconsin #Missing Missouri #Missing Iowa #Missing Colorado #Missing Central #Missing
See Also