The <ALLINSAMEDIM command selects all the members from the same dimension as the specified dimension member for the report.
<ALLINSAMEDIM mbrName
mbrName | Single member representing a dimension. All members from this dimension are selected. |
<ALLINSAMEDIM AudioSelects all the members from the dimension for the following report.
<PAGE (Market, Accounts, Scenario) Chicago Sales Actual <COLUMN (Year) <ICHILDREN Year <ROW (Product) <ALLINSAMEDIM Audio !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 Audio 5,741 5,497 5,599 7,009 23,846 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 Visual 10,795 10,102 11,812 14,365 47,074 Product 16,536 15,599 17,411 21,374 70,920
Copyright (c)1991-2000 Hyperion Solutions Corporation. All rights reserved.