Prevent the Removal of Items Because of Accidental Changes

When you run a demand plan and choose to refresh it with current data, existing items that are no longer within the scope are removed from the plan.

When such items are removed, their associated data in measures, including user-adjusted measures, is normally deleted and lost.

Intentional and unintentional changes made to Product dimension hierarchies or on the Scope tab on the Plan Options page for the plan can result in the removal of items. For example, you added an item with an additional level to an existing hierarchy, and data is now returned by default for only those items at the lowest level and not any intermediate level. For items at a higher level for which data was being returned before the change, no data is returned now, and these items are deleted.

To prevent the removal of items because of accidental changes to Product dimension hierarchies or on the Scope tab, do these steps:

  1. On the Plan Options page for your plan, click the Demand tab.
  2. Click the Select Advanced Options button.
  3. In the Demand: Advanced Options dialog box, under Forecasting Control Parameters, in Parameter Overrides, enter the following: enableItemsDeletedCheck=true
  4. Save your changes.

Results:

After you make this change, when you run your plan and refresh it with current data, if the number of items to be removed after the plan run exceeds 10% of the number of items in your plan’s scope, the following happen:

  • The plan completes in the warning state.
  • The items aren’t marked as deleted and are still associated with the plan.
  • Item data in measures, including user-adjusted measures, is preserved.
  • The items are still displayed in tables along with existing and newly added items. However, in some cases the parent-level information for the items to be deleted might not be available, and Not available is displayed in place of the parent-level name.

    Graphs and tiles that return aggregated information for these items are also affected.

  • A warning on the Review Plan Messages page informs you about the percentage of items that are going to be removed from your plan’s scope. This warning message is also logged.
  • The names of the first 100 items are stored in the logs of the Snapshot Plan Members job of the Run Plan/Batch Run Plan job set in the Scheduled Processes work area.

    The names of all the removed items are stored in the service server logs.

If the removal of items isn’t planned, you can amend your Product dimension hierarchies or selections on the Scope tab and run your plan while refreshing it with current data to restore your information.

What to do next

If the removal of the items is as planned, do the following:

  1. Enter enableItemsDeletedCheck=false in the Parameter Overrides field in the Demand: Advanced Options dialog box.
  2. Run the plan again while refreshing it with current data.

    The items are finally deleted from your plan’s scope, their associated measure data is deleted, and the warning message is no longer displayed.

  3. To reenable the data preservation logic, enter enableItemsDeletedCheck=true in the Parameter Overrides field in the Demand: Advanced Options dialog box.