'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
@Brj73
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'.
We are pleased to announce the upcoming FCR 2611.1 GA release scheduled for the week of November 16th, 2026. Highlights Enhanced User Interface for Process Parameter Selections When selecting parameters to run processes in Anaplan FCR, users can now quickly locate and select dimension members using an enhanced, interactive…
Check out the latest Anaplan feature updates and enhancements in our October 2026 official release notes. There you'll find information on: User Experience Updated Field Components Intelligence CoModeler AI Gateway Anaplan Analyst Anaplan XL Reporting Excel integration and reporting Web and mobile experience Security and…