SET FRMLBOTTOMUP

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;
Parameter Description

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 this setting by using CALCOPTFRMLBOTTOMUP TRUE in the essbase.cfg file.

Notes

  • For information on complex formulas and top-down calculations, see the Oracle Essbase Database Administrator's Guide.

  • 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 the SET FRMLBOTTOMUP 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;

See Also