Copy KF1@ MTHPRODLOC to KF2@MTHPRODLOCLOCFR planning level

[ayanbishnu1981]

I have a key figure called KF1@KF1@ MTHPRODLOC I want to copy the value of that KF to a different KF called KF2@MTHPRODLOCLOCFR. Now in this case KF2@MTHPRODLOCLOCFR will have 2 entries in the source location MDT. one such records will be having LOC3 location as the LOCFR and the other record let say have LOC4 as the LOCFR attribute. What I am exactly looking for is value from KF1@ MTHPRODLOC should first get copied to KF2 at the MTHPRODLOC level, let say using copy operator and then the KF2 will dissagg the value to the correct LOCFR level, where i don't have the indicator X in the attribute "Location Source Invalid" in the SOURCELOCATION MDT. So the value of KF1 should be saved in KF2 at the level where my LOCFR is LOC3 location as I haven't maintained X in the attribute "Location Source Invalid".

I know how to use the Dissagg operator to achieve this. What I am looking for is could thier be any other way that we can achieve the same result using attribute transformation or writing complex dissagg expression or something else like using source or target conversion feature in the planning level in KF2 so that the value is saved without using any operator.

Even I tried to use advance copy operator using the attribute section where I said LOCFR = LOC3 at the target KF. But the copy operator is not updating the values even though it executes successfully without any error or warnings.

Let the best minds come together in this virtual platform as see what we can come up with.

Special request to irmhild.kuntze and mkorndoerfer for your suggestions.

Ayan

[piyush_parekh · Accepted solution]

Hi Ayan,

Please check if below helps:

1. Configure attribute as key figure KF1 at PRODLOCLOCFR level. Maintain value equal to 1 for all combination. Configure KF2 at PRODLOCLOCFR with calculation - if Source Invalid, KF2 = 0 else KF2 = KF1

2. Create target KF at PRODLOCLOCFR with calculation KF2 at PRODLOCLOCFR multiplied by source KF at PRODLOC. If both sources are valid, both LOCLOCFR will get values equal to source KF.

Regards,

Piyush

[ayanbishnu1981 · Accepted solution]

Thanks a lot for sharing the details. After doing some tweaks and transformation based on your recommendation I am able to get the desired output.

[Irmi_Kuntze]

yeah that should work

Just keep in mind please for the AAKF that the planning level should NOT have any time dimension, as otherwise you will blow up your data. Will work without time dimension as well

[ayanbishnu1981]

Thanks Irmhild

It works abosultely fine even without a time period. Posting 1 more question for currency and its conversions as I havent worked on currency after 1908 version. Will tag you for your inputs.