Key Figure Calculation Doubt

[pallavidwivedi108]

Hello All,

We want to create an editable Key figure such that the value is replicated throughout the Planning Horizon until any manual edit is made by the user. Post the manual edit, the new value should be replicated in the future periods.

Example >>

Assuming KF1 is the editable Key figure

Here the update of 10 is made in Wk1 by the user. For Wk2 to Wk4, no updates are made. In Wk5 manual edit of 30 is made by the user. Hence Wk5 onwards 30 should get replicated till the next manual edit which is in Wk9

Has anyone configured anything similar in IBP using Key Figures?

Thanks,

Pallavi

[AyanBishnu · Accepted solution]

Hi Pallavi

From what I understood from your requirement, that user inputs to a particular weekly bucket should be auto populated until the next manual input bucket arrives. In your example I could see that the input periodicity is 4 weeks and I assume that the periodicity might change based on certain factors. To me the best way to achieve this by using 2 KFs and a VBA macro.

For example create 2 KFs KF1 and KF2. Make the KF1 fully editable. In this KF1 user should put values in the buckets similar to your example (WK1, WK5 & WK9).

Now in KF2, you can write an expression as follows

If a particular bucket@KF1 is not NULL copy the value to KF2.

Now you need to create a VB macro( should be a simple one), which will refer to KF2 and check the count of blanks between to buckets to identify the periodicity and copy the value of the first bucket to all the blank buckets in between. In this way you can tackle cases where the input difference could be variable ( e.g you example have 4 buckets of periodicity, but even if the periodicity is variable, the excel macro can count and populate the values accordingly).

The only downside of this approach is that you need to make sure that all users installs the vba macro during the time they install the IBP addin for excel.

Let me know if this works for you.

regards

Ayan Bishnu

[pallavidwivedi108 · Accepted solution]

Hi Ayan,

Thank you for your inputs. As you rightly pointed out, the periodicity of the manual input can vary. As a first approach i want to explore this using KF calculations. If nothing works, then macro is always an option.

Thanks,

Pallavi

[AyanBishnu · Accepted solution]

Hi Pallavi

The only challenge that you cannot work with standard KF expression, is that you cannot control bucket specific calculation using KF expression. KF expression will work on a single uniflow logic (e.g you cannot write KF expression to say copy the wk 1 value to wk2, 3 and 4).

Other option could be Lcode, but that is something that will cost additional, as SAP has to do it.

[anil_gupta8]

Thanks let someone reply... I don't know how to.....

[anil_gupta8]

I see.... agree not sure how this work.. copy operator ? how system shows to change manual entry 30 W5 should replicate up to WK8

[pallavidwivedi108]

The interval of manual changes is not fixed. Also would prefer values to replicate automatically and not using any operator. Hence Copy Operator will not work.

[anil_gupta8]

Try - use attribute as key figure ... define time period from to ... include that attribute lets say unit cost in product master .

if this setup is done than planning will show unit cost maintained in product master from to period same value . you can now change in planning view different value test

[pallavidwivedi108]

Hi Anil,

Attribute as a KF will not work since the updates made later on will not replicate in the future periods. I have updated the question with a screenshot of the image. That might help clear out the requirement.

Thanks,

Pallavi