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