Using your Essbase Cube - Oracle Essbase 9 Implementation Guide - page 217

We say to be cautious because if there is ever a question about the report script
generated data, it will not always be the easiest to track down or debug. Again,
nice functionality, but use it very carefully.
All calculation commands must be enclosed in
curly braces as shown.
CALCULATE COLUMN
Syntax:
{CALCULATE COLUMN "newColumn" = expression }
Example:
{CALCULATE COLUMN "Actual YTD" = 1 + 2}
This example will create a new column called Actual YTD which will be the sum
across of columns 1 and 2 . Again, if the Actual YTD value does not exist in Essbase,
it may be difficult to debug the data displayed on the report, unless you are
intimately familiar with the report script itself.
ONCOLCALCS
Syntax:
{ ONCOLCALCS }
Example:
{ ONCOLCALCS }
This command must be used in the script prior to coding the CALCULATE COLUMN
command to turn on the column's calculating ability.
OFFCOLCALCS
Syntax:
{ OFFCOLCALCS }
Example:
{ OFFCOLCALCS }
This command must be used in the script after coding the CALCULATE COLUMN
command to turn off the column's calculating ability.