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;