Level 2 Model Building Conclusion - DEM04 Demand Export Demand values

CamilleDeBo
CamilleDeBo
edited November 2022 in Academy Discussions

Hi,

 

Could someone please help me with the following?

 

Solution DEM04 should be this:

CamilleDeBo_0-1664888747605.png

My DEM04 Demand Export:

CamilleDeBo_1-1664888797667.png

My values are way higher, Demand line item is not for each product SKU. How can I fix this?

 

My DEM04 blueprintview:

CamilleDeBo_3-1664888993629.png

Baseline Forecast: 

CamilleDeBo_2-1664888842804.png

Thanks in advance!

 

Tagged:

Comments

  • Misbah
    Misbah
    edited November 2022

    @CamilleDeBo 

     

    If you look at the dimensionality of DEM03 it is P3 SKU and Accounts where as in DEM04 it is P3 SKU and G3 Location, there is one dimension which is not matching. I would say think about how you aggregate the data from DEM03 to DEM04. You are missing SUM function in the formula.

     

    X[SUM:Y], Here Y is the mapping between Accounts and G3 Locations.

    Hope that helps

    Misbah

    Miz Logix

  • CamilleDeBo
    CamilleDeBo
    edited November 2022
    Thank you!
    I will try to solve it.
    Kind regards,
    Camille
  • ShirleyV
    ShirleyV
    edited November 2022

    @Misbah 

    Hi, 

    I found the only list have relationship of Accounts and Location is SYS09.

    I put the formula as below but it does not work.  Any hint?

     

    'DEM03 Demand Forecast'.Final Forecast[SUM: 'SYS09 Account Details'.Code]
  • Misbah
    Misbah
    edited November 2022

    @ShirleyV 

     

    Try something from SKU details module where you see Distribution center as line item.

     

    Thanks,

    Misbah

    Miz Logix

  • ShirleyV
    ShirleyV
    edited November 2022

    @Misbah 

    I tried to use SYS08 with distribution center for Demand='DEM03 Demand Forecast'.Final Forecast[SUM: 'SYS08 SKU Details'.Distribution Center] but it returns total demand per SKU not by location.

  • JWags
    JWags
    edited November 2022

    I need help too on this matter,
    I have been looking for the solution for more than 5 hours now and this is my last day of access to the platform. I need to get my certification before tomorrow.

  • nhatduytk012
    nhatduytk012
    edited November 2022

    Hi, you need refer to  account detail  location , not SKU detail location because DE03 is having account demension

  • TyroneW
    TyroneW

    Is this correct? Can someone please check?

    'DEM03 Demand Forecast'.Final Forecast[SUM: 'SYS09 Account Details'.Location]

  • AjayM
    AjayM

    Hi @TyroneW ,

    That's correct to sum final forecast by G3 location, for each SKU.

    While P3 SKU is common dimension between DEM03 and DEM04, SYS09 provides linkage between Accounts and Location.

    Cheers!

  • TyroneW
    TyroneW

    Thank you @AjayM !

  • dpong8898
    dpong8898

    It should be 'DEM03 Demand Forecast'.Final Forecast[SUM: 'SYS09 Account Details'.Location] instead of Code

Categories