SET FRMLBOTTOMUP
Optimizes the calculation of complex formulas on sparse dimensions in large database outlines. This command tells Analytic Services to perform a bottom-up calculation on formulas that would otherwise require a top-down calculation.
Syntax
SET FRMLBOTTOMUP ON|OFF;
| 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. |
Description
The SET FRMLBOTTOMUP command optimizes the calculation of complex formulas on sparse dimensions in large database outlines. You might want to turn on this setting when using the
CALC ALL;and CALC DIM; commands to calculate the database.