Essbase CALCMODE

Enables global setting of formula execution mode.

This setting does not apply to aggregate storage databases.

Syntax

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.

Description

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

Example

CALCMODE BLOCK

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

See Also

@CALCMODE function