CALC ALL

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