IBP KF calculation - How to bring calculated values to current bucket if it lies in past week

[former_member590183]

Hello IBP gurus,

I have an KF1@WKPRODLOC which is offset by lead time in backward using KF2@WKPRODLOC, while doing this if the lead time is 8 weeks but the order is placed in 4 weeks in future, KF1@WKPRODLOC goes back to past.

Does anyone have an idea how to bring KF1 to current week ?

I tried this below but it didn't work.

KF1 @WKPRODLOC = IF ( "PERIODID4" < "$PERIODID4CU$" , "PERIODID4" , "KF1 @WKPRODLOC" )

Thanks

Karthik

[former_member242371]

Hi Karthik,

From what i understood, you are trying to bring KF1 from past bucuket to current.

You can use attribute transformation for this purpose. Let me know if your requirement is different.

Thanks,

Rohit

[former_member590183]

Hi Rohit,

Thanks for your response.

Please see my attached requirement in excel. I am already using period transformation to calculate KF1.

Any idea how to automatically bring to current week ?

[former_member590183]

Does anyone has suggestions on this ?

Thanks

Karthik

[former_member242371]

Hello Karthik,

Is there a reason you shifted the value to past using attribute transformation and then trying to bring it again in current bucket? I feel it could have been shifted to current week in the first place.

Now, You may use PERIOD_SHIFT option in copy operator to shift the values of KF1 to current week and then store it in some other key figure. However period shift will be a constant value and need to be changed when time rolls.

Thanks,

Rohit