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

MDXLIMITFORMULARECURSION

You can use the MDXLIMITFORMULARECURSION configuration setting to remove Essbase Server limitations on the number of execution levels allowed for MDX calculated members or formulas.

When set to false, MDXLIMITFORMULARECURSION does not prevent Essbase Server from exceeding 128 MDX formula execution levels. You can use this if you know that a recursive execution in a formula/calculated member will eventually terminate, and you want Essbase to continue processing it.

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

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.