CALCLIMITFORMULARECURSION configuration applies only to block storage (BSO) databases, and does not apply to aggregate storage (ASO) databases.

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 Essbase Server. Setting CALCLIMITFORMULARECURSION to TRUE prevents excessive execution levels.

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.

Example

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:

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