Total Pageviews

Monday, July 28, 2025

Calc Scripts

                                     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