I am getting an error putting this formula to the shipping time(weeks).
'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product,LOOKUP:'SYS07 Distribution Center Details'.Default Shipping]
error:Dimension of mapping used for lookup doesn't match any dimension of the result
can someone help me with this?
Try the below:
'TRA01 Shipping Metrics by Week'.'Shipping Time (Weeks)'[LOOKUP: Final Shipping Method, LOOKUP: 'SYS08 SKU Details'.Product]
I have the same issue. There is no data in the TRA01 module. Should I import anything? can't find this information in the sprint.
I have got the data in shipping time(weeks).In the TRA01 module, try applying the yearvalue() function ,you will get the data.
I managed to solve it but thank you anyway 🙂