'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method]
After applying this i am not getting data populated in shipping time week line item
You're on the right track, you're formula is correct, but you may have overthought the formula. Take a look at YEARVALUE function. This is a better function since its basically a LOOKUP on the time hierarchy. make sure the TRA01 values are showing up.
YEARVALUE('DAT02 Shipping Metrics'.'Shipping Time (Weeks)')
Thanks i got it
I had not applied formula in TRO1 shipping metrics by week so it was empty and not populated
Hi I used the function you provided but it is not working for me because of 'level mismatch on common dimension'.