IDESCENDANTS

Adds the specified member and its descendants to the report.

Syntax

<IDESCENDANTS mbrName

When used as an extraction command in conjunction with the <LINK command, the syntax is:

<IDESCENDANTS (mbrName [, gen/levelName [, AT|UPTO]])

Parameter	Description
mbrName	Name of single member and descendants to add to the report.
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

Adding the descendants of the top of the dimension adds all the members in the dimension to the report, including the dimension top.

Example

Example 1

<IDESCENDANTS Product

Adds all the members from the Product dimension to the report since all the members are descendants of the member Product which is the top of the dimension. Audio and Visual are the children of Product. Stereo and Compact_Disc are the children of Audio while Television, VCR, and Camera are the children of Visual.

<PAGE (Market, Accounts, Scenario)
Chicago Sales Actual
<COLUMN (Year)
<ICHILDREN Year
<ROW (Product)
<IDESCENDANTS Product
!

This example produces the following report:

                     Chicago Sales Actual 

                 Qtr1   Qtr2   Qtr3   Qtr4    Year
              ======= ====== ====== ====== =======

Stereo          2,591  2,476  2,567  3,035  10,669
Compact_Disc    3,150  3,021  3,032  3,974  13,177
  Audio         5,741  5,497  5,599  7,009  23,846
Television      4,410  4,001  4,934  6,261  19,606
VCR             3,879  3,579  4,276  4,877  16,611
Camera          2,506  2,522  2,602  3,227  10,857
  Visual       10,795 10,102 11,812 14,365  47,074
    Product    16,536 15,599 17,411 21,374  70,920

Example 2

<LINK(<IDESCENDANTS(Market,"Lev0,Market")) 
OR 
<LINK(<IDESCENDANTS(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 
    Market       #Missing

Example 3

<LINK(<IDESCENDANTS(Market,"Lev0,Market",UPTO)) 
OR 
<LINK(<IDESCENDANTS(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