Skip to Content

Copy Value from one period of KF1 to multiple Period of KF2

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


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Apr 11 at 06:31 AM

    Hi,

    Did you try using PERIOD_SHIFT parameter in COPY operator?

    Regards,

    Anurag

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 11 at 08:08 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 11 at 08:43 AM

    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


    Add comment
    10|10000 characters needed characters exceeded

  • Apr 11 at 10:30 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 11 at 11:46 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 11 at 01:18 PM

    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

    Add comment
    10|10000 characters needed characters exceeded