SCALE

The SCALE command in Essbase Report Writer scales the data in the report by multiplying it by a numeric value.

Syntax

{ SCALE factor [ columnList ] }

Parameters

factor: Numeric value by which all output values are multiplied. The result is a scaled value.
columnList: Optional. List of column numbers that this command affects.

Notes

SCALE command affects only the report columns specified in the command, or all columns, if none are specified. Stored data is not affected.

Example

The following report script is designed for the Demo Basic cube, available in the gallery. The command {SCALE .01} multiplies the data values in the second report by .01.

<PAGE (Market, Accounts, Scenario)
Chicago Sales Actual
      <COLUMN (Year)
      <CHILDREN  Year
<ROW (Product)
<CHILDREN Audio 
     !

{SCALE 2}
Chicago Sales Actual
      <CHILDREN Year
<CHILDREN Audio 
     !

The above report script example produces the following report:

                    Chicago Sales Actual

                 Qtr1   Qtr2   Qtr3   Qtr4 
              ======= ====== ====== ====== 
Stereo          2,591  2,476  2,567  3,035 
Compact_Disc    3,150  3,021  3,032  3,974 

                    Chicago Sales Actual
                                  
                 Qtr1   Qtr2   Qtr3   Qtr4 
              ======= ====== ====== ====== 
Stereo          5,182  4,952  5,134  6,070
Compact_Disc    6,300  6,042  6,064  7,948