CALCMODE

The CALCMODE Essbase configration setting enables global setting of formula execution mode.

By default, these modes are off (hybrid mode is the default).

This setting does not apply to aggregate storage cubes.

Syntax

CALCMODE [appname [dbname]] [BLOCK | BOTTOMUP]

appname—Optional. If you specify an application, all the cubes 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.
dbname—Optional. If you specify an application and cube, the cube you specify is affected by the CALCMODE setting. If you do not specify an application with the cube, the CALCMODE setting will fail.
BLOCK—Turns on block calculation mode.
BOTTOMUP—Turns on bottom-up calculation mode.

Description

CALCMODE configuration setting allows you to set the calculation mode at the server, application, or database (cube) level instead of indicating it in a calculation script using @CALCMODE.

Example

CALCMODE BLOCK

Turns on block calculation mode for all cubes and applications in the server.