ALLSIBLINGS
The Essbase Report Writer ALLSIBLINGS command adds all the siblings of the specified member to the report.
Syntax
<ALLSIBLINGS mbrName
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