ALLSIBLINGS

The Essbase Report Writer ALLSIBLINGS command adds all the siblings of the specified member to the report.

Syntax

<ALLSIBLINGS mbrName

Parameters

mbrName

Name of member whose siblings you want to add.

Example

The following report script is designed for the Demo Basic cube, available in the gallery. <ALLSIBLINGS Stereo selects the siblings of the member Stereo.

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

 <COLUMN (Year)
 <ICHILDREN Year

<ROW  Product)
<ALLSIBLINGS Stereo
 !

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

ANCESTORS

DESCENDANTS