Sample 11: Placing Two-Page Layouts on the Same Page
This Essbase report script sample demonstrates how to build two different layouts on the same page.
Year Profit_% Actual
East West South Market
========= ========= ========= =========
Stereo -0.52% 1.91% 0.00% 0.91%
Compact_Disc 32.60% 36.00% 0.00% 34.60%
Audio 17.86% 20.81% 0.00% 19.60%
Television 20.40% 16.57% 13.50% 17.21%
VCR 30.81% 32.43% 33.70% 32.24%
Camera 16.66% 21.66% 17.83% 19.07%
Visual 23.16% 23.56% 22.27% 23.09%
Product 21.34% 22.50% 22.27% 22.04%
Sales Actual Product
Qtr1 Qtr2 Qtr3 Qtr4 Year
========= ======== ======== ======== ========
New_York $18,631 $17,681 $19,923 $24,403 $80,638
Boston $15,812 $15,050 $16,716 $19,159 $66,737
Chicago $16,536 $15,599 $17,411 $21,374 $70,920
East $50,979 $48,330 $54,050 $64,936 $218,295
San_Francisco $19,761 $19,019 $20,722 $24,807 $84,309
Seattle $13,766 $13,546 $14,204 $19,034 $60,550
Denver $13,800 $13,588 $13,838 $18,232 $59,458
Los_Angeles $17,866 $17,269 $17,208 $22,635 $74,978
West $65,193 $63,422 $65,972 $84,708 $279,295
Dallas $ 9,226 $ 9,175 $ 9,481 $12,700 $40,582
Houston $ 7,690 $ 7,363 $ 7,646 $10,785 $33,484
Phoenix $ 8,157 $ 7,903 $ 8,343 $11,843 $36,246
South $25,073 $24,441 $25,470 $35,328 $110,312
Market $141,245 $136,193 $145,492 $184,972 $607,902
Use the following script to create Sample 11:
<PAGE (Year, Accounts, Scenario)
<COLUMN (Market)
<ICHILDREN Market
<ROW(Product)
<IDESCENDANTS Product
Actual
{ DECIMAL 2 WIDTH 10 SUPBRACKETS AFTER "%" }
Profit_%
!
<PAGE (Accounts, Scenario, Product)
Actual
Sales
Product
<COLUMN(Year)
<ICHILDREN Year
<ROW(Market)
{ DECIMAL 0 After " " BEFORE "$" }
<IDESCENDANTS Market
!
In a single report, you can select multiple dimension layouts and members. To define a multiple layout report, define reports as you normally do. Separate the commands with exclamation marks as shown above. Whenever the column, row, or page dimensions change between ! output commands, new headings are automatically generated to match the new layout.
The BEFORE format command places a character in front of data values. The AFTER format command turns off the percent signs from the first report layout.