Filtering Results

Filtering enables you to display only results that meet certain criteria. For example, you can set the criteria to show only members that have warning messages. The default is to show results for all members. When filtering criteria are changed, all open forms are updated:

  • By default, member rows that do not meet the filtering criteria are collapsed to hide them. You can change this setting in the General Options dialog (Setting General Predictive Planning Options).

  • The member list in the Results View is changed to show only members that meet the filtering criteria and the view is updated.

Note:

Filtering is a global setting. It applies to all forms and persists from one session to the next. If you save a filtered workbook and reopen it later, you can display hidden rows by performing a Refresh in Oracle Smart View for Office.

To filter Predictive Planning results:

  1. In the Predict ribbon, select Filter Results.
  2. In the Filter Results dialog, select a category:
    • Prediction status—The type of icon shown in the comments: Success, Warning, or Error

    • Prediction accuracy—Determined by a formula based on MAPE (mean absolute percentage error)

    • Error measure (RMSE, root mean squared error, MAPE, or MAD, mean absolute deviation)—The error measure to use for selecting the best time-series forecasting method, specified in the Settings dialog.

  3. Select a conditional operator: = (equal to), <> (not equal to), <= (less than or equal to), >= (greater than or equal to)
  4. Select or enter a value. For Prediction accuracy, values range from 0%-100%; for Error measure, from 0 to +infinity or 0%-100%, depending on the selected measure.
  5. Optional: Click Add Row to define another set of selection criteria. Multiple rows of criteria must all be satisfied to select a member (an AND operation).
  6. Click OK to display members that meet the selected criteria.

    Note:

    At any time, you can click Reset to remove all selected criteria and display results without filtering.