CALC DIM

The CALC DIM command calculates the formulas and aggregations associated with each member of all the specified dimensions.

Syntax

CALC DIM (dimList);

dimList Dimension or comma-delimited list of dimensions to be calculated.

Description

This command calculates the formulas and aggregations associated with each member of all of the specified dimensions. The order in which dimensions are calculated depends on whether they are dense or sparse. All of the dense dimensions are calculated first, in the order that the dense dimensions appear in dimList. The sparse dimensions are then calculated in a similar order.

Example

CALC DIM(Accounts);

CALC DIM(Dense1,Sparse1,Sparse2,Dense2);

In this last example, the calculation order would be: Dense1, Dense2, Sparse1, Sparse2. If your dimensions need to be calculated in a particular order, use separate CALC DIM commands, as in:

CALC DIM(Dense1);
CALC DIM(Sparse1);
CALC DIM(Sparse2);
CALC DIM(Dense2);