CALCOPTFRMLBOTTOMUP

Parameters

CALCOPTFRMLBOTTOMUP specifies whether Hyperion Essbase optimizes the calculation of complex formulas on sparse dimensions in large database outlines. If enabled, this setting tells Hyperion Essbase to perform a bottom-up calculation on formulas that would otherwise require a top-down calculation.

Syntax

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.

Description

This setting tells Hyperion Essbase 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 calc script.

Notes

• For information on complex formulas and top-down calculations, see the Hyperion 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 CALCOPTFRMLBOTTOMUP setting in a production environment, be sure to check the validity of calculation results produced when the setting is enabled (set to TRUE).

Example

CALCOPTFRMLBOTTOMUP TRUE

See Also

SET FRMLBOTTOMUP (calculation command)

Copyright (c)1991-2000 Hyperion Solutions Corporation. All rights reserved.