Replacing an Attribute by another in a copy operator or any calculation definition in a Key Figure

[former_member579319]

Hello,

I have the key figure SALEFORECAST with a planning level PRODLOCCUST, that I’ll disaggregate to a second key figure with a planning level PRODLOCCUSTLOC2, finally I have to copy this again to a PRODLOC, but I need to link the LOC2 with LOC in this last copy, in other words, replace the LOC by the LOC2 in a copy process. What is the best way to do this?

[former_member242371 · Accepted solution]

Hello Giampiero,

You can use attribute transformation to transform LOC to LOC2.

Create a planning level PRODLOCCUSTLOC2NEW similar to PRODLOCCUSTLOC2 and define transformation-

LOC2@PRODLOCCUSTLOC2NEW = LOC---------> Input KF@PRODLOCCUSTLOC2

Now the kf is available at PRODLOCCUSTLOC2NEW planning level where LOC is replaced by LOC2.

Using this KF@PRODLOCCUSTLOC2NEW define a new calculated key figure -

KFnew@PRODLOCCUSTLOC2NEW = KF@PRODLOCCUSTLOC2NEW

Use KFnew as source in copy operator.

For detail attribute transformation steps, see below link-

https://help.sap.com/viewer/bf99e931b8d44aafb4e306ec3602cbdd/1708/en-US/1834135510fdec14e10000000a44...

Thanks,
Rohit