Setting the Forecast Horizon for Competitive Forecast Execution

The Forecast Horizon setting on a competitive forecast group controls how far into the future all methods in that group produce forecasts. It overrides individual method extrapolation settings and ensures that all competing methods forecast the same number of periods. This approach makes the comparison fair and the output consistent.

For example, the competitive forecast group CompClass4-Growing has a Forecast Horizon of 1 Year and includes the methods T MA4 Prev Year, Holt Linear 0.5/0.2, Auto ARIMA, Auto ETS, and Auto THETA. When the group runs on a monthly model, the Forecast Horizon setting overrides the extrapolation settings of the individual methods, causing all methods in the group to generate forecasts for 12 future periods. The method selected as the winner, or the resulting ensemble forecast, then writes 12 forecast periods to the database. Any extrapolation settings defined for individual methods are ignored.

The behavior is to override the ExtraPeriods value defined for individual forecasting methods. For example, if a method is configured to extrapolate 24 periods but the competitive forecast group specifies a Forecast Horizon of 12 periods, the method generates a forecast for only 12 periods. This behavior applies to both the holdout and recalculation phases, ensuring a consistent forecast horizon throughout the competitive selection process. If the Forecast Horizon is set to Per Method Setting, the forecast uses the ExtraPeriods value defined for each individual method.

  1. From the menu, select Data > Statistical Forecast Methods > Competitive Forecast Methods.
  2. In Competitive Forecast Properties, select Execution.
  3. Specify this information:
    Forecast Horizon
    Select an option from the list. This table shows the available options:
    Setting Value Monthly model Weekly model
    Per Method Setting Uses the setting defined on the winning method
    Quarter 0.25 year 3 periods ahead 13 periods ahead
    Third Year 0.33 year 4 periods ahead 17 periods ahead
    Half Year 0.50 year 6 periods ahead 26 periods ahead
    Two-Thirds 0.67 year 8 periods ahead 35 periods ahead
    Three Quarters 0.75 year 9 periods ahead 39 periods ahead
    Full Year 1 year 12 periods ahead 52 periods ahead
    Year and Half 1.50 year 18 periods ahead 78 periods ahead
    Two Years 2 years 24 periods ahead 104 periods ahead
  4. Click OK.
    Note: The selected value is stored in the ForecastCompFcst table, in the ForecastHorizon column.