Using parent members as cross dims in FIX is taking long time for script to complete
Summary:
We are trying to fetch parent values in a business rule to perform spread calculation. But since these are top level members and having storage property as dynamic calc, its impacting the performance of script. The script is taking hours to run. Is there any way to optimize the rule?
Content (required):
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
IF("Final Spread"->BegBalance == [[SL_Spreads_Methods.PMPM_Spread]])
@CALCMODE(BOTTOMUP);
"Total Plan"->"BegBalance" * ("A_4013S"->"Calculated PMPM"->"OEP_Plan"->"OEP_Working"->"All Product"->"All Site"->"All Cost Center"->&PlanStartYr/"A_4013S"->"Calculated PMPM"->"OEP_Plan"->"OEP_Working"->"All Product"->"All Site"->"All Cost Center"->&PlanStartYr->"YearTotal");