Skip to Content

IBP forecast error - Show MAPE on Excel UI

Hi experts,

I am trying to run show the MAPE error in the excel planning view on a Key figure.

When I go to Manage Forecast tile on Fiori and go to post processing steps, I can't choose any KF as all of them appears as Incompatible.

Could you please let me know the steps to show MAPE forecast error at the Excel UI?

Many thanks

Best regards,

Juan Carlos

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Mar 12 at 01:19 PM

    Hello Juan Carlos,

    A Key Figure is only valid to be used as the result of error measure in the Postprocessing step if it meets all the below points:

    • Make them time-independent by not adding any periodicity to the planning level they belong to
    • Select the Stored option for them
    • Select Copy Value for the disaggregation mode

    You may find additional information about this in our SAP Help Portal Postprocessing Steps, section Activities. Additionally, you may refer to our Model Configuration Guide - Time-Independent Key Figures for more information about time-independent Key Figures.

    Best regards,
    Matheus

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 15 at 12:00 PM

    Hello Matheus,

    Thank you. I have managed to add my KF on the post-processing step now with the time independent KF.

    Could you please tell me the steps to show the error now in Excel UI?

    Thank you very much.

    Best regards,

    Juan Carlos

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 27 at 11:06 AM

    Hi Juan,

    You will have to create some KFs as below:

    KF1 (stored , All Editable) in same attribute level as error say WKPRODLOCCUST. (Include Week) and provide value 1 for all buckets and combinations for which you calculate the errors.

    KF2 (calculated) again on WKPRODLOCCUST a calculated KF = KF1@WKPRODLOCCUST * FORECASTMAPE@WKPRODLOCCUST.

    Display KF2 in your excel view.

    Hope this helps.

    regards,

    Anurag

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 08 at 11:17 AM

    Hi Anurag,

    I have tried creating three KFs:

    KF1 --> MAPE (Without PER) (I can see the calculated value as an alert)

    KF2 --> MAPEAUX (Same level as above but with PER)

    KF3 --> KF1xKF2

    The PA is correctly activated but the result is still null for KF3, as if the value for MAPE at planning level PER... is not defined at all…

    I need MAPE to be stored in a KF so that I could use it within an alert…

    Thanks for your support.

    Esther

    Add comment
    10|10000 characters needed characters exceeded