Enabling Rolling Forecast

Enabling rolling forecast allows planners to perform continuous planning beyond a one-year timeframe. After you enable rolling forecast, use the Planning and Forecast Preparation configuration task to configure rolling forecast to plan continuously at a weekly level for either 13, 26, or 52 weeks, at a monthly level for either 12, 18, or 24 months, (and for Financials also for 30, 36, 48, or 60 months) or at a quarterly level for either 4, 6, or 8 quarters. In an application with a 13-period calendar, in Financials you can plan continuously at a period level for 13 or 26 periods.

By using the Planning and Forecast Preparation configuration task to define the rolling forecast range and using the provided forms, it's easy to implement a rolling forecast. Rolling forecast is primarily used in Financials for data entry and analysis, but if you enable rolling forecast for Projects, you can analyze projects over the defined rolling forecast time period range.

When you enable and configure rolling forecast:

  • Rules, forms, and dashboards for rolling forecast planning and analysis are created.

  • Forms and dashboards are designed so you can view the entire rolling forecast range. Valid intersections are used to control what displays.
  • When you update the current time period, forms and dashboards are automatically updated to add or drop new time periods as needed to reflect the updated rolling forecast range. Trends and drivers are populated to newly added time periods. Valid intersections are used to make the forms dynamic.

  • For Financials, a new member (OEP_Rolling Forecast) is added to the Scenario dimension. Note that the standard forecasting member (OEP_Forecast) is still available so you can use the standard forecasting method that allows forecasting for a one-year timeframe and the rolling forecasting method.
  • Projects uses the OEP_Rolling Forecast member to dynamically display data in the rolling forecast range by referring to the forecast scenario (OEP_Forecast) for the corresponding period. It does not allow data entry for the OEP_Rolling Forecast member.
  • Two scenarios are added for KPIs for reporting purposes:
    • OEP_TTM (Trailing Twelve Months). This scenario reports the activity in Flow based accounts over the prior twelve months.
    • Projected 12. For Flow type accounts, this scenario reports on the sum of (current period + 11 future periods). For Balance type accounts – this scenario reports on a member value 12 periods in the future.

If you purchased EPM Cloud before June 4, 2019, you can convert a Standard or Reporting application to an Enterprise application. If you convert the application, planners can continue to use existing forms that use the converted application's rolling forecasting method because the form property that creates rolling forecast is still available in your custom cubes.

Watch this overview video to learn more about planning using a rolling forecast.

video iconOverview Video.

Watch this tutorial video to learn more about planning using a rolling forecast.

video iconTutorial Video.