rule optimisation

Dec 21, 2023 8:39AM

Summary:

Content (please ensure you mask any confidential information):

Hi

need your suggestion on below rule and how to optimize its performance.

SET UPDATECALC OFF; SET AGGMISSG ON;

FIXPARALLEL (4,{RTP_Entity})

FIX ({RTP_Version},@relative("Input Currencies",0),"No Future",

@relative("All SAP Accounts",0),"No Segment","OFS_Load",

@relative("Total Cost Center",0),@relative("Total Functional Area",0),@relative("Total Profit Center",0))

Fix (&LastPer1,&LastPer2,&LastPer3,&LastPer4,&LastPer5,&LastPer6,&LastPer7,&LastPer8,&LastPer9,&LastPer10,&LastPer11,&LastPer12,

&LastYr1,&LastYr2,&LastYr3,&LastYr4,&LastYr5,&LastYr6,&LastYr7,&LastYr8,&LastYr9,&LastYr10,&LastYr11,&LastYr12)

SET CREATENONMISSINGBLK on;

"Best Estimates"

(

if("OEP_Actual"->"SAP" != #missing)

"Best Estimates"->"OFS_Load" = "OEP_Actual"->"SAP";