Calculation Mode Function

The @CALCMODE function allows you to specify which the formula execution mode Essbase uses to calculate a formula: cell mode, block mode, bottom up, or top down. Without @CALCMODE, Essbase makes the determination based on its own analysis of data dependencies.

@CALCMODE: Specify the calculation mode (cell, block, bottom-up, or top-down) that Essbase uses to calculate a formula.

Note:

You can also use the configuration setting CALCMODE to set calculation modes to BLOCK or BOTTOMUP at the database, application, or server level.