This discussion is archived
2 Replies Latest reply: Mar 30, 2013 10:06 AM by AnkitArora RSS

How to Erase already generated forecast from Demantra

user99999999 Explorer
Currently Being Moderated
Hi All

We are new demantra user organization. Recently after Go-live we decided not to generate forecast for a bunch of items. Accordingly, we turned off the flag "Do not Do" forecast and rerun the engine. However, our forecasting horizon is for 102 weeks. So from previous weeks of engine run, we had forecast already in application for those items for 100+ weeks.

Now after, turning that flag off and rerunning the engine, demantra is not generating new forecast for them. But for old forecasts still remain in the system. How to erase these forecasts?

Any help will be appreciated.

Thanks

Roger
  • 1. Re: How to Erase already generated forecast from Demantra
    988339 Newbie
    Currently Being Moderated
    Hi,

    You have couple of options here:
    1. Consider to change the flag to "Do Zero Forecast", thus forcing engine to generate a ZERO Forecast for such old/inactive/disabled items. You will have to also get rid of any manual forecast overrides which you may have done in other series to completely reduce final forecast to ZERO.

    2. Check out "ResetForeVals" parameter in System Parameters > engine > Shell tab of business modeler. You may consider setting this parameter to a value of "Yes" or "All". Remember that a setting of "All" will affect engine run time, mainly the amount of time engine would take to clean up the FORE_X column prior to generating a new forecast.

    Thanks
    Raj
  • 2. Re: How to Erase already generated forecast from Demantra
    AnkitArora Newbie
    Currently Being Moderated
    Hi,

    You can do this thru program as well by setting the FORE_X column to zero(Pick FORE column dynamically from forecast_history table) in sales_data table for the sales_date <= max_sales_date.


    Thanks,
    Ankit

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points