<ANCESTORS

Command

The ANCESTORS command adds all the ancestors of the specified member to the report.

Syntax

<ANCESTORS mbrName

mbrName Name of member whose ancestors you want to add.

Example

<ANCESTORS Stereo

Adds Audio and Product to the following report since Audio is the parent to Stereo and Product is the parent to Audio.

<PAGE (Market, Accounts, Scenario)
Chicago Sales Actual

 <COLUMN (Year)
 <ICHILDREN Year

<ROW (Product)
<ANCESTORS Stereo
 !

This example produces the following report:

              Chicago Sales Actual 

              Qtr1   Qtr2   Qtr3   Qtr4   Year 
           ======= ====== ====== ====== ======
Audio        5,741  5,497  5,599  7,009 23,846 
  Product   16,536 15,599 17,411 21,374 70,920

See Also

IANCESTORS