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

Parameters

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 1 (DESCENDANTS)

<DESCENDANTS Year

Selects members Jan, Feb, Mar, Q1, Apr, May, June, Q2, Jul, Aug, Sep, Q3, Oct, Nov, Dec, Q4.

Example 2 (DESCENDANTS)

<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 

Example 3 (DESCENDANTS)

<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