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.
SET FRMLBOTTOMUP ON|OFF;
Turns on the bottom-up sparse formula calculation method.
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.
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).
SET FRMLBOTTOMUP ON;