Calculates and aggregates the entire database based on the database outline.
Syntax
CALC ALL [EXCEPT DIM (dimList) | MBR (mbrList)];
Parameter | Description |
---|---|
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" in the Oracle Essbase Database Administrator's Guide.
Example
CALC ALL; CALC ALL EXCEPT DIM(Product);
See Also