ANCESTORS

Adds all the ancestors of the specified member to the report.

Syntax

<ANCESTORS mbrName
ParameterDescription

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