Load New Budget Values

This Essbase calculation script example uses FIX and CALC DIM to calculate Budget values, and then recalculates the Variance and Variance % members.

Example script:

/* Calculate all Budget values */

FIX(Budget)
   CALC DIM(Year, Product, Market, Measures);
ENDFIX

/* Recalculate the Variance and Variance % formulas, which requires two passes */

Variance;
"Variance %";

Essbase performs the following actions:

1. Fixes on the Budget values.

2. Calculates all Budget values.

   CALC DIM calculates all the dimensions except for the Scenario dimension, which contains Budget.

3. Calculates the formula applied to Variance in the outline.

4. Calculates the formula applied to Variance % in the outline.