Hi everyone, I appreciate any help that can be provided, I was very stuck on the formula for Shipping Method.
I was trying the formula below and getting error "Format of mapping used for lookup doesn't match any dimension of the source". I believe I am using the correct module line items, but am struggling to understand why they are not giving the correct result.
'SYS07 Distribution Center Details'.Default Shipping[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: 'SYS08 SKU Details'.Distribution Center]
I found the linked that I copied below that explained that I only need one LOOKUP to the SYS08 Distribution Center and that the final formula is 'SYS07 Distribution Center Details'.Default Shipping[LOOKUP: 'SYS08 SKU Details'.Distribution Center]
I am still not entirely understanding why only one LOOKUP is needed when we want to look at both Distribution Center and Product SKU as criteria to determine the Shipping Method. I am assuming that it is because both the Distribution Center and P3 SKU list are in SYS08, but I am not understanding why you don't need to point the LOOKUPs to both the Distribution Center and the SKU?
Thanks again for any help, I really appreciate it!
Both SYS07 and INV01 have one dimension each, So if you are fetching data to INV01 from SYS07 you just need to connect DC dimension to P3 SKU (which is available in SYS08). You don't need to map or connect P3 SKU of SYS08 with P3 SKU of INV01 as both are the same dimension, Anaplan sees that.