Loading New Budget Values
This example calculates 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.
The CALC DIM command is used to calculate all the dimensions except for the Scenario dimension, which contains Budget.
Calculates the formula applied to Variance in the database outline.
Calculates the formula applied to Variance % in the database outline.