Specifies whether Analytic Services optimizes the calculation of complex formulas on sparse dimensions in large database outlines. If enabled, this setting tells Analytic Services to perform a bottom-up calculation on formulas that would otherwise require a top-down calculation.
This setting does not apply to aggregate storage databases.
CALCOPTFRMLBOTTOMUP TRUE | FALSE
TRUE | Optimizes the calculation of formulas on sparse dimensions in large database outlines by forcing a bottom-up calculation. |
FALSE | Does not force a bottom-up calculation for formulas on sparse dimensions in large database outlines. The default is FALSE. |
This setting tells Analytic Services whether to optimize the calculation of formulas on sparse dimensions in large database outlines, so that you can efficiently use CALC ALL and CALC DIM commands to calculate the database.
You can override the CALCOPTFRMLBOTTOMUP essbase.cfg
setting by using the SET FRMLBOTTOMUP command in a calculation script.
CALCOPTFRMLBOTTOMUP TRUE
SET FRMLBOTTOMUP
(calculation command)
SET CREATENONMISSINGBLK
(calculation command)
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |