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
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)').
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
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.