How to set up Attribute Transformation in SAP IBP
The explanation on the internet about how to do create attribute transformations in SAP IBP are very brief - and mostly wrong.
That's why here is the cookbook of how it works:
- You have a planning level LOCPROD which is defined monthly.
- You have a key figure SALESQTY on this level.
- You want an additional key figure SALESQTY1Y which is sales shifted by one year.
So this is what you have to do:
- Define a new planning level LOCPROD1Y having the same attributes and keys as LOCPROD
- Define a new key figure SALESQTY1Y with base planning level LOCPROD
- Define key figure calculation SALESQTY1Y@REQUEST = SUM("SALESQTY1Y@LOCPROD1Y"), Input key figure SALESQTY1Y@LOCPROD1Y
- Define key figure calculation SALESQTY1Y@LOCPROD = "SALESQTY@LOCPROD", Input key figure SALESQTY@LOCPROD
- Create an attribute transformation key figure for PERIODID3 (monthly).
- Define key figure calculation PERIODID3@LOCPROD = "PERIODID3" + 12, Input key figue SALESQTY1Y@LOCPROD
This is how it worked for me.