Creating a Forecast or Rolling Forecast Calculation

Create a forecast or rolling forecast calculation to look back at actuals data for time periods before a cut-over data, and look ahead to forecast data for subsequent time periods.

Prerequisites

The table in your story should have a version with data that you want to use for the forecast periods. If it does not have one, you can use Version Management to create one. For more information, see About Version Management.

Procedure

  1. Select your table.
  2. Under Rows or Columns in the Builder tab, select Add Measures/Dimensions and add the Cross Calculations dimension.
  3. In the Cross Calculations dimension, select Start of the navigation path Next navigation step Add CalculationEnd of the navigation path
  4. From the Calculation Editor Type, select Forecast or Rolling Forecast.
  5. In the Version list, select the version that contains the forecast data.

    This data will be displayed for time periods after the cut over date. Data from the Actuals version will be displayed for time periods before the cut over date.

  6. In the Cut over date area, specify a date.
    • Current Date: This is the default choice.
    • Last Booked Actuals: This means the latest date of data entered for the Actuals version.
    • Specific Date: In Click to Select Values, choose Select by Member and then, from the list, select the date.

    Generally, you cannot enter a cut-over date later than the current date. However, if you have selected the Last Booked Actuals option and the data in your model is for a later date than the current date, an exception is made and the cut-over date is set for future.

  7. From the Measure list, select the values that you want to use for the calculation.

    For example, for a model using currency conversion, select the conversion to use.

  8. Specify the Hierarchy to use for the date dimension, and then choose a time period from the Granularity list.
  9. Specify the length of time for the forecast:
    • For a Forecast, select an option from the Range list.
    • For a Rolling Forecast, specify the number of Look Ahead and Look Back periods.
  10. Choose OK.

Results

The table now shows actual and forecast values and the total value:

  • Calculation in column: The line below the column headings changes color or pattern at the cutover date, and the totals are in the final column

    Putting the Cut-over Date into table columns
  • Calculation in row: Each time interval has a row in the table and there is a total column for each data row.

    Putting the Cut-over Date into table rows