History cleaning with SAP IBP:-

Summary:

Introduction : why history cleansing

Steps to History Cleansing

Go To Mange Forecast Model App

1. Inside Forecast Model App go inside History Cleaning model.

2. History Cleaning model has  four tabs 1. General > 2. Pre Processing Steps > 3. Forecasting > 4. Post Processing.

3. With Pre processing Tab SAP IBP Provides four options 1. Substitute Missing Values 2. Outlier Correction 3. Promotion Sales Lift Estimation (removing any post promotion effect to sales)

4. Select one of the option Substitute Missing Values. Selecting Substitute Missing Values gives three options 1. Mean 2. Median 3. Give Value

6. Selecting mean, system will automatically calculate mean in the background and update the mean in the place of missing value. Selecting Given value will ask to update a number to to be updated in case something is missing

7. Update Time Scope of Substitution. It has three options 1. Full 2. History Only 3. Future only. Selecting History Only

8. Key-figure section selecting Input (Actual Qty) and output Key-figure (Actual Quantity Adjusted)