Forecast Import - Provide Endpoint to allow Quantiphi to trigger import of new forecast

As forecast models are continually adapting, and more information is known, there is sometimes a need to force a re-import of the forecast that was previously sent to InFORM. This feature would allow Quantiphi/AWS forecast team to “notify” InFORM that a specific store/date needs to be re-imported. Hitting this new API should automatically trigger InFORM to re-import the specified day/store combo.

----------

Under CFAMX-10369 we will be delivering a mechanism to help with the identification and re-importing of bad forecasts. However, should Quantiphi correct a forecast for a large number of stores, pulling them in manually is time consuming and involves logging a support ticket.

This feature will provide Quantiphi with an end point that will allow them to ask us to request a forecast for a specific store and date (one at a time).

----------

Current processes:

AWS Web Service

AWS Web Service tasks in Server Manager are used to pull in Forecasts between a range of days, as specified in the configuration.

• Date range =>
  • Start Date = Today + Offset Days
  • End Date = Start Date + Forecasting Days
• Only stores that are in the configured zone are requested/imported
• The steps are:
  • Status Call
  • Process Status Response (ExternalGenerationDate in db, vs generation time of file)
  • Demand Call(s), based on Status response
  • Import forecast(s)
  • Set All forecasts for stores in zone to Read Only = false, for dates between today and Start Date (including Start Date)

Request AWS Forecast Page

The forecast page makes the same calls as the AWS Web Service, however the date range requested/imported is based on the date range selected on the page, not the task configuration

• The steps are:
  • Status Call
  • Process Status Response (ExternalGenerationDate in db, vs generation time of file)
  • Demand Call(s), based on Status response
  • Import forecast(s)
  • Note: The task to change the read only flag does not run in conjunction with this process, if a newly imported forecast is for a date between today and the Start Date of the AWS task, the forecast will be marked as Read Only until the next time the Server Manager task is run.

New process - Quantiphi request that we call for forecast

• For some reason Quantiphi needs to regenerate a forecast that has previously been imported by InFORM
• The steps are:
  • Quantiphi generates new forecast
  • Quantiphi makes a call to InFORM requesting that InFORM import the forecast for that store & date
  • InFORM queues a message to preform a Status Call and then get the available forecast
  • If a new forecast is available, InFORM pulls in the new forecast
  • InFORM will queue up an Auto Notification, that will be send to Support, providing details of request made
    • Can we make this a smart notification that gets kicked off when the first request is made and waits for an hour before it sends, and when it does it includes everything requested within that hour?
  • If the forecast that is being replaced has been edited by a manager, an Auto Notification will be sent to the Store Contact informing them that a new forecast has been imported, replacing their edits.
  • Can we respond to Quantiphi to let them know that the manage edit will be replaced? Can we provide a flag that says override manager edit?