ONSAMELEVELAS

Adds to the report all members on the same level as the specified member.

Syntax

<ONSAMELEVELAS mbrName

Parameters

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

Notes

Levels are counted up from the bottom of the dimension. Members in the cube outline with no children are level 0; their parents are level 1, and so on. The level for a child is always 1 lower than its parent.

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)
<ONSAMELEVELAS Audio 
     !

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 
Visual             10,795   10,102   11,812   14,365   47,074