OFSAMEGEN

The Essbase Report Writer OFSAMEGEN command adds to the report the members from the same dimension and generation as the specified member.

Syntax

<OFSAMEGEN mbrName

Parameters

mbrName: Single member that designates the dimension and generation to retrieve.

Notes

Generations are counted starting at the top of the dimension. The top of the dimension is generation 1; its children are generation 2. Each child's generation number is one greater than its parent's.

Example

The following report script is designed for the Demo Basic cube, available in the gallery.

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

 <COLUMN (Year)
 <ICHILDREN Year

<ROW (Product)
<OFSAMEGEN VCR
 !

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