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