IBP_LPA in IBP 1908

[former_member559077]

I'm trying to setup the IBP_LPA as a Dynamic Aggregation. I'm getting this Error Pop Up when trying to do it.

"The ZDHINVONHANDQTY key figure in the stored calculation input must be a stored key figure":

I get that when I click on 'Validate':

Even when I put it as a store input:

According to IBP help: this is the way to accomplish the :

"AGGRINVENTORY@PERPRODLOC = IBP_LPA("INVENTORY@DAYPRODLOC") AGGRINVENTORY@REQUEST = SUM("AGGRINVENTORY@PERPRODLOC")"

I'm trying to set it up as closer as SAP explains it.

This is our Time Profile definition:

And this is our ZDINVONHANDQTY key figure definition:

I'm listing all the planning levels we have set up:

I would really appreciate suggestions in order to make it work.

[piyush_parekh · Accepted solution]

Hi,

For dynamic aggregation, make sure that no root time profile level is defined in the output planning level of the aggregation and in any of the calculations built on last period aggregation. Additionally, time profile levels must be the same in the input and output planning levels.

In your case, you are defining LPA calculation at LOCPROD level. It should contain all time levels same as that of LOCPRODWEEKLY and should not have any of the time profile level marked as root.

You may as well refer to SAPIBP1 sample planning model - ADJUSTEDIOSAFETYSTOCK key figure which has LPA calculation defined in it.

Hope this helps!

Regards,

Piyush

[former_member559077]

Thank you so much Piyush. I followed your inputs and it is working correctly now. Something I faced doing it though: After I created the the new Planning Level with no root for time profiles. Then when adjusting the key figure with the new planning level, I was still getting the error "The ZDHINVONHANDQTY key figure in the stored calculation input must be a stored key figure". So I had to completely delete the key figure and create it again, after which the error was no longer there. And I was able to activate the new key figure without problems. After testing it in the Excel UI, it worked as expected. This is what was done:

New Planning Level with no root for time profiles:

Key Figure configuration:

Excel UI results as expected:

For Technical Weeks, Weeks, and Month time periods:

For Month, Quarter, and Year time periods:

Considerations:

- For the monthly aggregation for September you can see a value of 52. This is taken from last technical week value for September (TW40a = 52). Technical Week 40b corresponds to October.

- For the weekly aggregation for week 40 you can see a value of 61. This is because week 40 is splitted between TW40a and TW40b; therefore, it is taken from the last value which is contained in TW40b.

- When the last period of a level aggregation still don’t have a value. That level aggregation will be empty. For example, for October there is no value because the last technical week for October has not been reach yet with a value.

I really appreciate your help Piyush!

[piyush_parekh]

Glad it worked out!! Thank you for putting detailed steps and final result! Appreciate it.