Define a baseline forecast timeframe

You must identify one or more dimensions that represents time in the cube you use for forecasting.

About this task

The time dimension (or dimensions) should include members for future time periods that correspond to the timeframe for which you want to create a forecast.

Procedure

  1. On the Timeframe page, click Add dimension(s).
  2. Select the dimension or multiple dimensions that represent time in your cube.
    In the case of multiple dimensions, you should order the dimensions as you would in an exploration, with the more general time period followed by the more specific time period. For example, if your cube includes the dimensions Year and Month, your configuration would look like this.
    Multiple time dimensions in a baseline forecast

    You can click a dimension and drag it to a different position if necessary.

  3. When you specify a time dimension, the dimension uses the default hierarchy and the set is Selection.

    Click the Options icon to change the hierarchy for a time dimension or to define a new set.

    Options icon with Replace Hierarchy and Open Set Editor options shown

    If you define a new set, you must explicitly save the set with a name.

    Click Drop-dowm menu icon to select a different set or level for the time dimension.

  4. Click Select start period to define the start of your forecast.
  5. The Forecast period end is automatically set to the last member of your time dimension (or dimensions, in the case of multiple time dimensions). You can click the menu icon Drop-dowm menu icon to pick a different end period.
  6. Optionally, you can ignore some historical time periods in your forecast.

    To ignore periods after a specific point in time, click After, then click Select ignore time periods and select the start of the historical time period that should be ignored. Any period after the selected period is ignored when generating a forecast.

    To ignore an individual time period, click Individual, then click Select ignore time periods and select the individual historical time period that should be ignored

  7. Click Next.

What to do next

Specify the scope of a baseline forecast