Sample 14-A: Basic Calculated Columns
This Essbase report script sample generates needed report columns using mathematical calculations.
East
Actual Budget Var
Jan Feb Mar Qtr1 Jan Feb Mar Q1 Q1
====== ====== ====== ====== ====== ====== ====== ====== =======
1,295 1,132 553 2,980 Tele~ Profit 1,240 950 950 3,140 (160)
25 27 14 66 Profit_% 26 22 22 70 (4)
56 62 59 177 Margin_% 60 60 60 180 (3)
1,417 1,120 898 3,435 VCR Profit 1,466 1,161 1,161 3,788 (353)
33 30 24 87 Profit_% 35 31 31 98 (10)
61 61 62 183 Margin_% 63 63 63 189 (6)
400 272 256 928 Cam~ Profit 528 360 360 1,247 (319)
15 11 10 36 Profit_% 19 13 13 45 (10)
70 70 70 211 Margin_% 71 71 71 213 (2)
3,112 2,524 1,707 7,343 Visu~ Profit 3,234 2,471 2,471 8,175 (832)
25 24 17 66 Profit_% 27 23 23 74 (7)
61 63 63 187 Margin_% 64 64 64 191 (4)Use the following script to create Sample 14-A:
<PAGE(Market)
East
<COLUMN (Scenario, Year)
Actual Budget
Jan Feb Mar
{ CALCULATE COLUMN "Qtr1" = 2 : 4
CALCULATE COLUMN "Q1" = 5 : 7
CALCULATE COLUMN "Var~Q1" = 8 - 9
ORDER 2,3,4,8,0,1,5,6,7,9
WIDTH 7 WIDTH 10 0 1
}
<ROW (Product, Accounts)
<ICHILDREN Visual
<CHILDREN Accounts
!