CALC ALL

The CALC ALL calculation command calculates and aggregates the entire Essbase database based on the database outline.

Syntax

CALC ALL [EXCEPT DIM (dimList) | MBR (mbrList)];

Parameters

EXCEPT: Defines an exception list of dimensions or members to be excluded from calculation.
DIM: Single-dimension specification.
dimList: Optional comma-delimited list of dimensions.
MBR: Single-member specification.
mbrList: Optional comma-delimited list of members, member set functions, or range functions.

Notes

The order in which dimensions are processed depends on their characteristics in the outline. For more information, see Defining Calculation Order.

Example

CALC ALL;
CALC ALL EXCEPT DIM(Product);