LEVEL 2 SPRINT 3 Shipping time weeks



For Shipping Time weeks, below was the logic i applied and it went through, however the data i am getting is '0'  

'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method]

to further break down i searched for other modules for shipping method dimension but no luck,  the shipping method within INV01 module is not a numbered format unlike others so may be it must be an error, got stuck. Can someone please help me understand 


Best Regards

Ankur Kulkarni 


  • Thank you Jared,  upon checking my DAT02 module in level 2 model had 0 values so re imported and  everything works fine. However,  assignment view has 'ending inventory values different from week 5 onwards compared to what i got. 1st screenshot is of assignment 

    2nd screenshot is of my model building result and 3rd screenshot is of the formulation. I happen to check the source file as well for values.  I am confused as my ending inventory is positive 




    2nd screenshot- my results 




     3rd screenshot - line item formulation



  • Misbah



    Beginning Inventory for Week 2 onwards has to be Ending Inventory of Previous Week. In Your Screenshot Beginning Inventory of Week 1 is 13000 and Ending Inventory is 10952 which is perfect but for Week 2 Beginning Inventory has to 10952 and not 13000 which means you will have to check the formula that you have written for Beginning Inventory Line item. 

    If I were you I would check SYS01 Time Setting by week Module and see if 'Not First Week of Timescale' line item has only Week 1 unchecked and rest all weeks should be checked.


    Hope that helps


  • Hello there


    I am facing same kind of issue, as suggested, I did double check on system module for booleans, it looks good. Please advise. Thanks.

  • The screenshot in lesson also displays incorrectly. I think it should look like this



    instead of 



    Maybe I'm yet to discover this in upcoming lessons.

  • Thanks. I am doing something wrong in formula for shipping time weeks and order receipt.

  • Hi, I followed you but getting values Zero. May i Know why it happening. whwere should i check


  • I'm confused on one thing: why are we using:
    'DAT02 Shipping Metrics'.'Shipping Time (Weeks)'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method]
    and not:
    'DAT02 Shipping Metrics'.'Shipping Time (Weeks)'[LOOKUP: 'SYS08 SKU Details'.Supplied By, LOOKUP: Shipping Method]
  • Can anyone help me with the formula needed for DAT02 Shipping Metrics?

    would really appreciate your help! thank you!

    Jennick S. Pedroza