LEVEL 2 SPRINT 3 3.3.5.2 Shipping time weeks

ankulkarni

 

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 

JaredDolich

 

@ankulkarni 

Your syntax is perfect so it's not the formula. DCA is involved here, so make sure you're drivers are set correctly and that when you hit the checkbox for Submit Purchase Order Request? it enables the line items. The next step after that is to make sure your 'TRA01 Shipping Metrics by Week'.'Shipping Time (Week) line item is calculating correctly. For that line item you should see something like this: YEARVALUE('DAT02 Shipping Metrics'.'Shipping Time (Weeks)'). 

See if any of that helps.

 

ankulkarni

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

@ankulkarni 

 

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

Misbah

Shahenaz

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.

SudhirY

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

 

instead of 

 

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

Shahenaz

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

sdasmasulthana

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

 

jadefortunato

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]

 

?

JennickPedroza

Can anyone help me with the formula needed for DAT02 Shipping Metrics?

would really appreciate your help! thank you!