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
CALCMODE BLOCK
Turns on block calculation mode for all databases and applications in the server.
@CALCMODE function