Automate clearing ’Review Forecast’ at alert level

A new macro is added to automate clearing ’Review Forecast’ at the alert level.

  • Clear Review Forecast - current selection and measure context (worksheet)

For example, selecting an Alert open base item-location combinations in exceptions that match the criteria for that Alert. The macro when executed from this panel clear the Review Forecast measure for that list of item-location combination using a %measurecontext% filter. This provides a better user experience when resolving or dismissing alerts.

These worksheets are updated to include a macro button (shortcut) in the panel menu:

  • DPLS Exception List
  • DPLS New Items Exception List

Business metrics are added to these alerts, which are calculated measures, therefore correctly processed by the macro:

  • DPLS_MISSINGFORECAST
  • DPLS_FBIAS_ERROR
  • DPLS_NEWITEMS
  • DPLS_FMAPE_ALERT
  • DPLS_FMAPE_WARNING
  • DPLS_FERR_M_ALERT
  • DPLS_FERR_M_WARNING

These business metrics are added to all standard Demand cycles.

The process of clearing Review Forecast considers that the related item-location combinations are reviewed and hence they are removed from all alerts in which they previously existed.

Note: This feature is available after loading the demand planning template (dpls.zip) for this release. The macro is accessible for these standard roles:
  • Demand Planning Administrator user in the Demand module (IBP_DPLS_DemandAdmin)
  • Demand Planning Participating user in the Demand module (IBP_DPLS_DemandNormal)
  • Demand Essentials Administrator (IBP_DPLS_EssentialsAdmin)
  • Demand Essentials Demand Manager - Key Forecaster (IBP_DPLS_EssentialsNormal)
  • Demand Planning Main System Administrator (IBP_DPLS_SystemsAdmin)

Alternatively, these permissions can be added to appropriate roles from Configuration > Security > Roles.