Negative Forecast in IBP

[Former Member]

Hi Experts,

Even though, Below Global Parameter has been maintained, we still have negative Forecast. Is there anything else which can prevent Negative Forecast?

• Parameter Group: FORECAST
• Parameter Name: MIN_FORECAST
• Parameter Value: 0

[mkorndoerfer · Accepted solution]

Hi Denish,

The Global Parameter MIN_FORECAST is only applied to the Target Key Figure for Forecast of the Forecast Model, and not specific to the algorithms. For example, see the screenshot forecast-model.png, you have 2 output Key Figures:

• Statistical Fcst Qty --> final output value of the algorithm, after calculating for all algorithms involved in the Forecast Model
• Triple Expo Smoothing Fcst Qty --> output value of a specific algorithm

So in this case, MIN_FORECAST is applied only to Key Figure Statistical Fcst Qty.

Best regards,
Matheus

[Irmi_Kuntze]

Sorry, my mistake, I mixed the two use cases as I was working on that one just at the time. You do NOT need HISTORY_MIN_VALUE (that is only used in conjunction with FORECAST_ESCAPENULL in order to replace NULL values in the history.)

Your setting MIN_FORECAST = 0 should be sufficient, it is strange that the result is still negative.

The only reason I can imagine that you still have negative values is that you may have had negatives the last FC run, and the new one might not have changed the data as your setting might have prevented that. Try to wipe out the FC (e.g. with the master data workbook on planning combination, or via the job template to delete versions) before you re-run it. Or check the business log for explanations. If you dont find it out, provide the business log to analyse in here

Yours

Irmi

[Irmi_Kuntze]

Hi Denish

you need in addition Parameter HISTORY_MIN_VALUE, they only work together. See model config guide for the details

Irmi

[Former Member]

Thank you, Irmhild !

HISTORY_MIN_VALUE is Set is 0.000 and this is the default value. Should this be changed to anything else?