Essbase SET FRMLRTDYNAMIC

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;
Parameter Description

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;