What is a calculation script?
Series of commands, equations, and formulas that control calculation of the database
Text files with a .csc extension.
/* Creates Initial Budget */
SET UPDATECALC OFF;
CLEARDATA Budget;
Budget = Actual * 1.1;
CALC ALL;
=============
1. What is the difference between Calc Dim and Calc All?
Calculating Dimensions
*Aggregate one dimension and calculate its formulas:
CALC DIM (dimension);
*Aggregate all dimensions and calculate all formulas:
CALC ALL
2. What is the difference between Calc All and AGG?
Calculating Dimensions
*Aggregate all dimensions and calculate all formulas:
CALC ALL;
*Aggregate a sparse dimension:
AGG (dimension);
3. Clear Data
*Clear dynamic calc and store members:
CLEARBLOCK Dynamic;
No comments:
Post a Comment