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.
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.
|
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.
SET FRMLBOTTOMUP ON;
CALCOPTFRMLBOTTOMUP (configuration file setting)
Set Commands
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |