Skip to Content
0
Oct 31, 2022 at 08:51 AM

Disaggregation of key figure value 0 if lower time level is null

465 Views Last edit Nov 08, 2022 at 03:01 PM 4 rev

Hi everyone,

Please consider (in SAP IBP) a calendar week that covers two different technical weeks and an editable key figure (base planning level on technical week). Further assume that the technical week A has key figure value 0, technical week B has key figure value NULL and the calendar week has key figure value 0. If (in the SAP IBP Excel-AddIn), I type in the key figure value 0 again on this calendar week and save the change, technical week B has still value NULL. Now, this is an issue if a user wants to set to 0 a (big) range of calendar weeks and this key figure is used to manually oversteer another. In this case, later, this key figure may still pull some other values than 0 in technical week B from other key figures. Does anyone know a possibility how to avoid that, i.e. make sure (e.g. by changing the configuration somehow) that in this case technical week will be set to 0?

I already tried to fix it by using a period weight factor, but the behaviour is still the same. If you have any questions or the need of clarification of the question, please let me know.

Thanks a lot for any hint!

Best wishes,

Alain

Technical details:

Version Excel Add-In 2111.6.0

Key figure configuration details: see attachment technical-configuration-details.jpg

Update:

I changed the proportionality of the diasaggregation to Same Key Figure - Stored Values, but the described situation above didn't change. In the attachment you'll find now also a screenshot of the applied disaggregation expression and a screenshot of the configuration details of the key figure used in it. Does anyone has an idea, how to solve this issue?configuration-details-of-disaggregation-key-figure.jpg disaggregation-expression.jpg