Hi Neeraj,Can you execute COPY and SCM (optimizer) operators in a sequence using one application job template ?Without COPY operator you cannot achieve what you are expecting. If I understand your requirement correctly that you want to avoid manual e...
Hello Anand,
Below approach will give expected result
1. Create a helper KF (HKF1) and put conditions using PERIODIDn and populate value KF2 from current to current + 5 weeks and beyond this populate value 0 2. KF1@PERPRODLOCCUST = IBP_CAGGR ( “HKF...
Hello Pallavi,
For me everything seems fine. You have masked dis-aggregation expression in KF2, May I know what does it do ? Also can you wipe KF2 values for sample PROD-LOC-CUST combination using Create Master Data workbook option ("Planning Objec...
Hello Pallavi,
This is very standard calculation. May be we are making mistake unknowingly. Could you paste KF2 and KF5 screenshots here (you can mask names. Just wanted to see calculations). Also try to cleanup the data and test with new set of da...
Hello Pallavi,
I hope you must have defined KF2 as IF(ISNULL( "KF2@PL" ), "KF1@PL" , "KF2@PL" ) which means KF2 is Stored and Calculated KF. So in KF5, you want calculation to be KF4 + KF1 when there is no value explicitly entered in KF2 else pi...