With an understanding of the Calc All function, we can now be comfortable describing the two very useful and related database calculation script functions.
Where the Calc All function is used to calculate the entire database based on the outline (consolidations and stored member formulas), the CALC DIM and AGG functions are used to perform almost the same function with dimension level precision.
The CALC DIM function performs exactly like the Calc All function in that it will execute calculations based on the database outline and Store Data tagged member formulas, with one huge difference. In calculating, functionality is constrained to only the database dimensions you list with this function. The following is an example of how you would code a CALC DIM statement to calculate only the Calendar Periods dimension.
To CALC DIM one dimension:
CALC DIM("Calendar Periods");
To CALC DIM more than one dimension in one command:
CALC DIM("Calendar Periods","Model Year","Market...
