Sample 14-B: Asymmetric Columns
This Essbase report script sample generates two regular columns defined in asymmetric mode.
For an explanation of the use of asymmetric columns, see Sample 13: Creating Asymmetric Columns.
East
Budget Actual Actual
Jan Jan % Sales
======== ======== ========
1,200 Television Payroll 1,236 25%
440 Marketing 365 9%
1,240 Profit 1,295 26%
4,800 Sales 5,244 100%
1,030 VCR Payroll 1,044 25%
150 Marketing 156 4%
1,466 Profit 1,417 35%
4,200 Sales 4,311 100%
1,195 Camera Payroll 1,167 42%
300 Marketing 288 11%
528 Profit 400 19%
2,850 Sales 2,656 100%
3,425 Visual Payroll 3,447 29%
890 Marketing 809 8%
3,234 Profit 3,112 27%
11,850 Sales 12,211 100%
Use the following script to create Sample 14-B:
<PAGE(Market)
East
<COLUMN(Scenario, Year)
Budget Actual
Jan Jan
{ ORDER 2,0,1,3,4 WIDTH 12 0 1 NOINDENTGEN AFTER "%" 4
SKIPONDIMENSION Product LMARGIN 10 }
<ROW(Product, Accounts)
{ CALCULATE ROW "Sales" OFF }
{ CALCULATE COLUMN "Actual~% Sales" = 2 % "Sales" 2 }
<ICHILDREN Visual
{ SAVEROW } Sales
Payroll
Marketing
Profit
<DUPLICATE Sales
!