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

CALCLIMITFORMULARECURSION

When set to true, this Essbase configuration setting prevents the server from going beyond 128 formula execution levels.

Syntax

CALCLIMITFORMULARECURSION TRUE | FALSE

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

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

Description

CALCLIMITFORMULARECURSION limits the number of execution levels of Essbase formulas. If a calculation involves formulas referencing one or more members from sparse dimensions and there are formulas along dense dimension members, the formula execution may be recursive (have multiple execution levels). Formulas with excessive execution levels may crash the server. Setting CALCLIMITFORMULARECURSION to TRUE prevents excessive execution levels from crashing the Essbase Server.

If a formula reaches 128 execution levels and CALCLIMITFORMULARECURSION is set to TRUE (or default), Essbase stops processing that formula and writes error messages in the application log. If a formula reaches 128 execution levels and CALCLIMITFORMULARECURSION is set to FALSE, Essbase continues processing that formula and writes an information message in the application log.

Note:

This setting does not affect formulas in MDX queries (for example, calculated members).

Example

Payroll / @SUMRANGE(Payroll, @IRDESCENDANTS(Market))

If you added a member named Payroll2 to the Measure dimension in Sample.Basic and used the following formula to calculate it, you would get a recursion error if Market has more than 128 members: