cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Disaggregation issue in IBP

former_member503200
Participant
0 Kudos
1,647

User manual update Key figure is disaggregating the data equally in technical weeks. All our planning is done in weekly buckets and causing issues with negative No’s when used in further calculation

Key figure config is as given below.

Agg Mode: SUM

Disagg Mode: Proportional if aggregation value is not zero; otherwise equal distribution.

Period Weight factor: WEEKWEIGHT

DIsagg Expression: Proportional factors.

Time Bucket TW9a TW9b Stat Fcst 945 268 User adj -333 -333 Final Fcst 612 -65

Accepted Solutions (1)

Accepted Solutions (1)

Irmi_Kuntze
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Jeff

from your description I cannot see how disaggregation should come into place:

If you have 268 in TW9b and the user adjusts by -333, and the final result calculates stat - adjustment, than the result is negative and for me it looks as the system just does what you designed it for

But maybe that is not what you wanted to say? Maybe you can make a screenshot of before and after for better understanding. Especially on which level had the data been adjusted, and what is the expected result compared to the real result

Answers (1)

Answers (1)

former_member503200
Participant
0 Kudos

The data got skewed. Any help is appreciated.

thx

Jeff