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

rule optimisation

Received Response
43
Views
3
Comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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