CALC DIM
The CALC DIM calculation command for Essbase calculates formulas and aggregations for each member of the specified dimensions.
Syntax
CALC DIM (dimList);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);