You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!