Enables global setting of formula execution mode.

This setting does not apply to aggregate storage databases.


CALCMODE [application_name [database_name]] [BLOCK| BOTTOMUP]
  • application_name—Optional.
    If you specify an application, all the databases in that application are affected
    by the CALCMODE setting. If you leave out the application and database name
    parameters, the CALCMODE setting applies to the entire server.
  • database_name—Optional.
    If you specify an application and database, the database you specify is affected
    by the CALCMODE setting. If you do not specify an application with the database,
    the CALCMODE setting will fail.
  • BLOCK—Turns on block calculation mode.
  • BOTTOMUP—Turns on bottom-up calculation mode.


CALCMODE allows you to set the calculation mode at the server, application,
or database level instead if indicating it in a calculation script using @CALCMODE.
For more information, see the calculator command entry for @CALCMODE in the Oracle Essbase Technical Reference



This entry in the .cfg file
turns on block calculation mode for all databases and applications in the

See Also

@CALCMODE function