SAP IBP: Last Period Aggregation

[former_member715896]

Hello experts,

I am trying to use LPA function to aggregate a key figure in Monthly level, however for some reason I am not able to reach the expected result.

Basically we have a Source KF (which has base planning level at CalendarWeek | Product | Location) and it's being copied via Copy Operator to a Target KF (Base PL: TechWeek | Product | Location).

The Target KF has aggregation for Month using LPA, however when we see the aggregation in the Planning View, it is considering the REQUEST level, which is SUM, instead of Last Period Aggregation. How can I achieve LPA in this case?

Please see attached image with configuration explanation.

Can anyone help me to figure out what is wrong with this configuration and how can I achieve Last Period Aggregation for the Target KF?

Thank you,

Best regards

[former_member654033 · Accepted solution]

Hello,

Please refer KF "PROJECTEDINVENTORY" in sample SAPIBP1 planning area for KF configuration reference, you are missing 1 additional panning level in calculation with no time attribute as root to make it work.

Please try and let me know if you still face any issues.

[former_member715896 · Accepted solution]

Hello Girish,

Thank you for your reply. That's exactly what I was missing and it worked now. Thank you very much!

[lokesh_reddy4]

HI,

Create one more key figure as below after copying the values to target key figure using copy operator.

LPAKF@MTHPRODLOC = IBP_LPA("TargetkF@WKPRODLOC")

~BR,

Lokesh Reddy