Using Predicted Values in Your Plans

For forms, after you run a prediction, for a more accurate and statistically-based forecast, you can copy predicted values and paste them into a scenario on the form.

For example, you can paste predicted values into a scenario named Forecast or Plan. You can paste values for only the currently selected member or for all members on the form.

Note:

If you want to save prediction data for later comparisons without overwriting other scenarios, an administrator can add a Prediction scenario to the form.

You can't paste values to ad hoc grids.

  1. To paste values for only a specific member, click the member on the form, or from the prediction results area, select the member from the member list.

  2. Make sure the form displays the time periods for the type of data used in the prediction. For example, to paste data for months, make sure that month members are displayed and not hidden in collapsed columns or rows.

  3. In the results area, click Prediction Paste icon (Paste).

  4. Specify the paste options:

    • Results: Which predicted values to copy, and the scenario to paste them to.
    • Prediction Range: The range of values to paste—the entire prediction range, or the number of periods you specify.
    • Members: Whether to paste values for only the currently selected member or all members on the form.
  5. Click Paste. The values in the grid are updated.

    If the prediction range overlaps the data range on the form, only the dates shown on the form are pasted.

    Members that are read-only on the form are predicted, but you can't paste results to read-only members.

  6. Click Save.