on 2023 Jan 19 5:52 PM
Hello Folks,
This is regarding rollover of unconsumed forecast.
The requirement is to roll over unconsumed forecast from one week to the next. This has to be done cumulatively.
In the ex below, the last row 'Updated Demand' has the cumulative unconsumed forecast.
Restriction is to rollover unconsumed forecast within that month only. So, for current Jan month, the open forecast cannot be rolled over from Dec month and the current unconsumed forecast for the Jan month cannot roll over to Feb month.
Had thought to use Dynamic Rolling aggregation (IBP_DYNAMIC_RAGGR), however, not sure how to ensure the constraints for maintaining the current month.
Any other direction?
Thanks
Request clarification before answering.
Hello Sameer
You can try the below configuration
UPDATEDDEMAND@PL = IBP_CAGGR("OPENDEMAND@PL",''SUM'',''FORWARD'',''PASTCURRENTFUTURE'',4)
Where 4 represents Month level at which you need to reset the calculation
The number 4 refers month in time profile as below
The result will look like below
Please go through some limitations in link
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
7 | |
5 | |
4 | |
1 | |
1 | |
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.