Period offset with Last period aggregation in IBP

[former_member585569]

Period offset with Last period aggregation in IBP,

We want to perform period offset in Projected inventory KF and store in separate KF, First I have have offset the inventory projection values and then I was trying to add Last period aggregation on this, But LPA not working .. Can you please me on this ? Thanks

[ankpatel]

Anil,

Source KF should be Stored KF.

Regards

Ankur

[ankpatel]

Hi Argha,

You will need 2 different KF - PERIODOFFSET and LPA

Once you have PERIODOFFSET, you have to do LPA on that particular KF. Use this note for your reference

Regards

Ankur

[former_member606529]

Hi Ankur,

Does this mean that PERIODOFFSET key figure needs to be stored or a calculated key figure would also work?

I'm trying a similar thing and its not working for me as well. Once I do the LPA on top of PERIODOFFSET attribute transformation done at PERIODID4 (Calender Week), the PERIODOFFSET attribute transformation is undone.

I have used calculated key figures.

Thanks,

Anil

[gurucharanscm]

Hi Argha - Please follow the note 2286684 for LPA to work.

Thanks,

Regards - Guru

[former_member585569]

Hi Irmi,

What I am trying is that .. We have projected stock (which is generated by heuristic), I need to offset these values by 4 weeks, For this I have created new KF "projected stock w/o LPA Offset and with period transformation I could able to offset these values by 4 weeks, but LPA logic is not working (see the values in Month), instead it is Summing the values across the weeks,

Can you please help me out on this requirement, Shall I Offset the values first and then try to put the LPA or the reverse way? and also if you could suggest some steps,then that will be a great help.Thanks

[gurucharanscm]

Hi Argha - where do you want to see the LPA logic here, plz post the expectation in an excel and what you did to achieve it so it's understood better.

Thanks,

Regards - Guru

[Irmi_Kuntze]

Hi Argha

the link https://help.sap.com/viewer/feae3cea3cc549aaa9d9de7d363a83e6/1808/en-US/135cde5620a62f7be10000000a44... explains how last period aggregation does work.

If you have more specific questions, than you should share screenshots / formula of your current trial and what error messages / issues you run into, otherwise it is hard to give any further hint

Yours, Irmi