1. Calculation and Query Reference for Oracle Essbase
  2. Calculation Commands
  3. Calculation Command List
  4. SET FRMLBOTTOMUP

SET FRMLBOTTOMUP

The SET FRMLBOTTOMUP calculation command optimizes the calculation of complex formulas on sparse dimensions in large database outlines. This command tells Essbase to perform a bottom-up calculation on formulas that would otherwise require a top-down calculation.

You might want to turn on this setting when using the CALC ALL and CALC DIM commands to calculate the database.

Syntax

SET FRMLBOTTOMUP ON|OFF;

Parameters

ON

Turns on the bottom-up sparse formula calculation method.

OFF

Turns off the bottom-up sparse formula calculation method. The default setting is OFF.

You can change the default behavior by setting the CALCOPTFRMLBOTTOMUP configuration setting to TRUE.

Notes

  • For information on complex formulas and top-down calculations, see Optimizing Calculations.

  • Forcing a bottom-up calculation on a formula may produce results that are inconsistent with a top-down calculation if:

    • The formula contains complex functions (for example, range functions)

    • The formula's dependencies are not straightforward

  • Before using this command in a production environment, be sure to check the validity of calculation results produced when the command is enabled (set to ON).

Example

SET FRMLBOTTOMUP ON;