Skip to Content
author's profile photo Former Member
Former Member

cleansing the historical data

Dear Experts

We have APO DP and using the statistical forecasts. We have been using this for a year now.

The problem is that the forecasts are showing at a higher side and we examined the history and it was loking very erratic.

We do have life cycle and promotion planning.

We have been told to cleanse this history data.

Can you please share how to go systematlcally to clean this data ?

Regards

KK

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 16, 2013 at 05:18 PM

    There are a few things you can do to let the system "cleanse" the historical data

    1) specificy an outlier correction value correctly. Try different values for different kinds of data..(observe visually)

    2) specificy an approproate outlier correction method

    3) Use historical value markings

    4) Nominate the promotion key figure in master forecast profile

    5) specify work days (time stream)

    6) Use an approprate forecast model by VISUALLY look at the history in graphic mode

    7) Have key figures like lost sales, returns etc in planning area.

    8) Have key figures for corrected history and corrected forecast in your planning area.

    Doing first 6 results in both a corrected history and corrected forecast in addition to system forecast. You can chose to update all these key figures in the planning book by making the settings in the planning area > extras

    In addition to this you can have key figure for lost sales, returns, unplanned promotional sales if any. Lost sales exraction can also be automated using a data source like VBFA (if you are using ECC) or simply some arbitray difference between customer orders and delivery quantities.. both are possible with some effort.. esle let planners enter lost sales manually based on their knowledge.

    Hope this helps.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 15, 2013 at 04:37 AM

    Hello KK,

    The Cleansing of Historical data totally depends on your own requirement.

    what is the erratic part in history.

    So as I understand based on your own needs you should change the history data.

    Regards,

    Anurag

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.