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:
-
Fixes on the Budget values.
-
Calculates all Budget values.
CALC DIM calculates all the dimensions except for the Scenario dimension, which contains Budget.
-
Calculates the formula applied to Variance in the outline.
-
Calculates the formula applied to Variance % in the outline.