SET FRMLRTDYNAMIC

The SET FRMLRTDYNAMIC calculation command for Essbase enables you to turn off calculation of dense Dynamic Calc dependencies during a batch calculation.

This command enables you to turn off calculation of all dense Dynamic Calc members during batch calculation if runtime dependent functions are included in formulas on stored members. (The preprocessing phase of a calculation script cannot determine if an outline contains dense Dynamic Calc members.)

This command improves batch calculation performance by removing the overhead of calculating all Dynamic Calc members.

The SET FRMLRTDYNAMIC command can be applied to an entire calculation script segment, as shown in the example below.

Syntax

SET FRMLRTDYNAMIC ON | OFF;

Parameters

ON

Calculation of Dynamic Calc members is performed. The default value is ON.

OFF

Calculation of Dynamic Calc members is not performed.

Notes

• Runtime-dependent functions include:

  • @ANCEST

  • @SANCEST

  • @PARENT

  • @SPARENT

  • @CURRMBR

• If a stored member formula includes a runtime-dependent function on a Dynamic Calc member, it may get #MISSING as the result instead of the expected value after executing the formula on the Dynamic Calc member.

Example

The following example turns off all dense Dynamic Calc members:

SET FRMLRTDYNAMIC OFF;
FIX(@LEVMBRS(Product, 0)))
"Avg Sales" = @AVGRANGE(SKIPNONE,Sales,@CHIDREN(@CURRMBR(Product)));
ENDFIX
CALC ALL;