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

RTDEPCALCOPTIMIZE

This Essbase configuration setting sets whether the @CURRMBRRANGE calculation function behaves as runtime dependent or non runtime dependent.

Syntax

RTDEPCALCOPTIMIZE [appname [dbname]] TRUE | FALSE

  • appname—Optional. If you specify an application name, the setting applies to all databases within the named application. If you do not specify an application name, the setting applies to all applications and databases on the Essbase Server.

  • dbname—Optional. If you specify a database name and an application name, the setting applies only to the named database. If you do not also specify an application name, the database is ignored and the setting applies to all applications and databases on the Essbase Server.

  • TRUE — @CURRMBRRANGE behaves as a non runtime dependent formula. This could result in incorrect calculation results if the @CURGEN or @CURLEV functions are used as arguments to @CURMBRRANGE, because Essbase would fail to generate the correct dependency list to compute @CURRMBRRANGE. This is the default.

  • FALSE — @CURRMBRRANGE behaves as runtime dependent formula, but only when @CURGEN or @CURLEV are passed as an argument to @CURRMBRRANGE. Calculations involving @CURRMBRRANGE may run slowly, as computation of runtime dependent formulas requires more memory.

Example

RTDEPCALCOPTIMIZE FALSE