<IDESCENDANTS

Command

The IDESCENDANTS command adds the specified member and its descendants to the report.

Syntax

<IDESCENDANTS mbrName

mbrName Name of single member and descendants to add to the report.

Description

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

Example

<IDESCENDANT 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