ANCESTORS

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

Syntax

<ANCESTORS mbrName

Parameters

mbrName: Name of member whose ancestors you want to add.

Example

The following report script is designed for the Demo Basic cube, available in the gallery. <ANCESTORS Stereo adds Audio and Product to the report (as 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 script 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

Related Topics

IANCESTORS