Calculates formulas and aggregations for each member of the specified dimensions.
Syntax
CALC DIM (dimList);
Parameter | Description |
---|---|
dimList | Dimension or comma-delimited list of dimensions to be calculated. |
Notes
The order in which dimensions are calculated depends on whether they are dense or sparse. Dense dimensions are calculated first, in the order of dimList. The sparse dimensions are then calculated in a similar order.
Example
CALC DIM(Accounts); CALC DIM(Dense1,Sparse1,Sparse2,Dense2);
In the above example, the calculation order is: Dense1, Dense2, Sparse1, Sparse2. If your dimensions need to be calculated in a particular order, use separate CALC DIM commands:
CALC DIM(Dense1); CALC DIM(Sparse1); CALC DIM(Sparse2); CALC DIM(Dense2);
See Also