on 2019 Jan 28 11:34 PM
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 -65Request clarification before answering.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 6 | |
| 5 | |
| 3 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.