The CALC ALL command calculates and aggregates the entire database based on the database outline.
CALC ALL [EXCEPT DIM (dimList) | MBR (mbrList)];
| EXCEPT | Defines an exception list of dimensions or members that are to be excluded from the 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. |
This command calculates and aggregates the entire database based on the database outline. The order in which dimensions are processed depends on the definitions of the various dimension in the database outline. Refer to the Database Administrator's Guide for more information.
CALC ALL; CALC ALL EXCEPT DIM(Product);
CALC DIM
SET UPDATECALC
SET CALCHASHTBL
SET FRMLBOTTOMUP
Copyright (c)1991-2000 Hyperion Solutions Corporation. All rights reserved.
