1. Configuration Reference for Oracle Essbase
  2. Essbase Configuration Settings
  3. Config Settings List
  4. MDXLIMITFORMULARECURSION

MDXLIMITFORMULARECURSION

When set to false, this Essbase configuration setting does not prevent the Essbase Server from going beyond 128 MDX formula execution levels.

Syntax

MDXLIMITFORMULARECURSION [appname [dbname]] TRUE | FALSE

  • appname—Optional. Specifies the application for which to set or remove the limit. If you specify a value for appname and do not specify a value for dbname, the setting applies to all cubes in the specified application. To enable the setting for a specific cube, you must specify an application and cube.

  • dbname—Optional. Specifies the database (cube), in the application specified by appname, for which to set the limit. If you specify a value for dbname but do not specify a value for appname, your specification is ignored.

  • TRUE—Imposes a limit of 128 on the number of MDX formula execution levels. The default setting is TRUE.

  • FALSE—Imposes no limit on the number of MDX formula execution levels.

Description

MDXLIMITFORMULARECURSION limits the number of execution levels of MDX calculated members or formulas. MDX calculated member or formula execution may be recursive (for example, a formula can refer to itself, or a calculated member can refer to itself). By default, Essbase limits the number of MDX formula execution levels, because formulas with excessive execution levels may lead to stack overflow errors and crash the server. However, setting MDXLIMITFORMULARECURSION to FALSE prevents Essbase from imposing the limitation. You can use this setting when you know that a recursive execution in a formula/calculated member will eventually terminate, and you wish to have a recursion depth greater than 128.

If an MDX formula reaches 128 execution levels and MDXLIMITFORMULARECURSION is not set, or is set to TRUE, Essbase stops processing that formula and writes error messages in the application log. If a formula reaches 128 execution levels and MDXLIMITFORMULARECURSION is set to FALSE, Essbase continues processing that formula.

Caution:

Before setting MDXLIMITFORMULARECURSION to FALSE, be sure that the MDX formulas in the outline are not infinitely recursive; for example, be sure that formulas do not depend on each other.