2310 Create DEM03 Demand Forecast Module

Solene
Solene
edited June 2024 in Modeling

Hi,

I need some help for my baseline forcast formula, please.

image.png image.png

Best Answer

  • Dikshant
    Dikshant
    Answer ✓

    Yes, match it with my screenshot. and then load the data again.

Answers

  • Solene
    Solene
    image.png

    trying another one but still don't work… any idea p[lease?

  • Dikshant
    Dikshant

    Baseline Forecast: IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN 'DAT03 Historic Volumes'.Offset Volumes for First Forecast Year ELSE OFFSET(Default Forecast, -52, 0)

    Offset Volumes for First Forecast: IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN OFFSET(Volumes, -52, 0) ELSE 0

  • Solene
    Solene
    edited June 2024

    Hi,

    I tried that but doesn't work …

    I may have done something wrong on a previous step but don't know which one.

    Here are my DEM03 and DAT03.

    image.png image.png
  • Solene
    Solene
    image.png

    Do I have to change the time range?

  • Solene
    Solene
    image.png

    Any ideas please… I am completely stuck !

  • Solene
    Solene
    image.png
  • Dikshant
    Dikshant
    image.png

    This is your screenshot, and it does not looks correct. Can you share the pivot of this module?

    SKU Flat List item does not looks correct to me.

  • Solene
    Solene
    edited June 2024
    image.png image.png
  • Dikshant
    Dikshant

    Okay, it's not a major issue, but please remove the SKU Flat List item from the list as it is not needed. Let me review it and try to identify any other potential issues.

  • Solene
    Solene
    edited June 2024

    Hi @Dikshant ,

    I removed it. thank you

    That changed my DEM03. does it looks good now ?

    image.png image.png
  • Dikshant
    Dikshant

    Please check the following items:

    Check if model calendar and time range are setup correctly. Make sure Current Period is setup as Week 1 FY20.

    image.png image.png

    Check the formula and result for SYS01 Module - 1st Forecast Year line item.

    image.png

    Check if DAT03 module matches:

    image.png

    Check default forecast and baseline forecast formulas are correct.

    image.png

    Make sure Growth percent line item format is set as percentage in both DEM03 and DEM02 module.

    image.png

    See if you were able to find the mistake.

  • Dikshant
    Dikshant

    Number looks way too off, check the above points and drill down on any cell and share the screenshot. It will tell us exactly which line item is off.

  • Solene
    Solene
    edited June 2024

    Dear @Dikshant

    • Calendar and time range are good. #
    image.png image.png
    • SYS01 seems good to me:
    image.png
    • DAT03:
    image.png

    Default forecast and baseline formulas

    image.png

    DEM02 and DEM03 are both in pourcentage decimal 2

    See my DEM03 results below:

    image.png
  • Dikshant
    Dikshant
    image.png

    Can you set this current period.

  • Solene
    Solene
    image.png
  • Solene
    Solene
    edited June 2024
    image.png

    is my DAT 03 right?

  • Dikshant
    Dikshant

    No it's way too off. Fix the DAT03 module. You have subsidiary views and mine does not have it. Can you correct that, dimension has to be P3 SKU and Accounts. Load the data again.

    image.png
  • Solene
    Solene

    I have updated my dimension.

    How can I remove my subsidiary ?

  • Solene
    Solene
    image.png image.png

    Great I guess it works now !

  • Solene
    Solene
    edited June 2024
    image.png image.png

    Last question: how can I change my value; should be 58.88 instead of 5,887,728,739?

  • Solene
    Solene
    edited June 2024

    I had to load again my DAT03 Historic volumes in my Datahub with dot instead of comma. Now looks good thanks !

Categories