Level 2 Model Building: Sprint 3 V1 :3.3.5 Activity: Create Inventory Ordering

Question

Hi everyone, I’m currently working on the TRA01 Shipping Metrics by Week task. My import action completes successfully but all records are ignored (0 updated, 424 ignored). Before troubleshooting further, could someone confirm whether this sprint expects the module to be populated via import or by using formulas? I want to make sure I'm following the correct implementation approach. Thank you!

Rizki Vidian · Answer

@namdevgurme thanks for your advice

namdevgurme · Answer

Hi @Rizki Vidian you are on right path but source module time dimension is Year and target module is Week.

Think formula how to bring year value to weekvalue.

Rizki Vidian · Answer

hii @namdevgurme

Thank you for your response.

I have already created formulas in the TRA01 Shipping Metrics by Week module, but the values are still not changing or populating as expected.

When you mentioned "bring values from Year value to Week value," could you please clarify where exactly this conversion should happen?

Should it be handled within the formula in TRA01, or is there a specific module or line item that needs to map the yearly values to weekly values (for example, using SYS01 Time Settings by Week)?

Also, does this refer to changing the Time Scale of the module, or is it purely a formula-based mapping?

I would appreciate any guidance. Thank you!