on 04-10-2018 4:11 PM
Hi Team,
I have a requirement to copy value from current period + 5 from KF1 and paste this into KF2 from current period + 6, till 20 Years. I am trying to use Dis-aggregation operator to achieve this but not getting the correct values. Is this right solution or there is some other better method to achieve this.
KF1 - Base planning level DAYPRODLOC, is marked as calculated and stored
KF2 - Base planning level WEEKPRODLOC, is marked as stored.
Disag operator Setup as below.
ATTRIBUTE1 = LOCID
PERIODID = PERIODID1
SOURCE_KFID1 = KF1
TARGET_KFID1 = KF2
PERIOD_OFFSET = 4
Thanks
Vilas Mhaisgawali
Hi Thomas,
I see that DISAGG operator is working perfectly with below Parameters. It is copying value of 5th year and adding to 6th year.
So to do this for 20 different period I would need to define 20 DISAGG operators which will fulfill the requirement but is a complex solution. I am trying to find simple solution to meet this requirement.
Thanks
Vilas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Thomas,
Thank you for the confirmation about DISAGG operator and suggestion. I will try to simulate your suggestion and let you know if that works.
Thanks
Vilas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vilas,
thanks for clarifying your requirement. The DISAGG operator does currently not support the copy from one period to multiple other periods with period shift. If this feature is important for you I would recommend requesting it via influence.sap.com.
To meet your requirement, you would need to define one DISAGG operator configuration per target period. You may group them in one application job template with multiple steps to simplify the monitoring of the execution.
Kind Regards,
Thomas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Thomas,
Below is the requirement.
Situation before disagg. operator is run
After disagg. operator is run, it should select value of KF1 for the Year = Current Year + 5 and copy this same value into KF2 from sixth year onward till end of Specified duration. Result shall look like below after operator run.
Thanks,
Vilas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vilas,
I am not sure if I fully got your requirement. In general, the DISAGG operator supports period shifts and offset. The parameter for period shift is PERIODSHIFT and for period offset PERIOD_OFFSET. Please note that the period shift and offset are calculated on the aggregation level where the data is copied. In your example PERIODID1.
Kind Regards,
Thomas Kretz
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Did you try using PERIOD_SHIFT parameter in COPY operator?
Regards,
Anurag
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
4 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.