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;