The ALLSIBLINGS command adds all the siblings of the specified member to the report.
<ALLSIBLINGS mbrName
mbrName | Name of member whose siblings you want to add. |
Siblings are all the members that have the same parent as mbrName in the Database Outline.
<ALLSIBLINGS StereoSelects the siblings of the member Stereo for the following report.
<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
Copyright (c)1991-2000 Hyperion Solutions Corporation. All rights reserved.