CALCMODE

The CALCMODE configration setting enables you to globally set the Essbase formula execution mode to block mode or bottom-up mode, instead of selecting these modes in individual calculation scripts.

By default, block mode and bottom up mode are off. Hybrid mode is the default calculation and query mode for BSO cubes.

CALCMODE configuration applies only to block storage (BSO) databases, and does not apply to aggregate storage (ASO) databases.

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 Essbase 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 Essbase 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 Essbase Server.