getting the error: "Dimension of mapping used for lookup doesn't match any dimension of the result"
I am doing level 1 model building(Activity-9.2.5 Activity: Add Formulas to Price Growth Rates Staging Module)
When i try to enter the formula for the lineitem 'Unit Price %' i get the following error- "Dimension of mapping used for lookup doesn't match any dimension of the result" .
My Formula- 'REV04 Price Growth Rates'.Unit Price %[LOOKUP: 'SYS04 Location Details'.Country, LOOKUP: 'SYS06 Product Details'.Product Family]
I went to the individual modules from where I am looking up and i can clearly see the respective columns.
What this means is that the line items formats you are using from SYS04 and SYS06 do not match the dimensions in REV05.
REV05 should be using G3 Location and P3 Products in the applies to. Take another look. If you're good there then check your system modules to make sure your line items are list formatted. You're super close.2
Thanks for correcting me. The granularity i used was not matching. I made the change you mentioned and its working now
Appreciate the help!!1
I have the same error message "Dimensions of mapping used for lookup doesn't match any dimensions..." for the same 9.2.5 Activity.
I verified that in REV05 the Applies To is using G3 Locations, P2 Products and that the Format is for Percentage.
I got the LOOKUP formula to work for Unit Cost %, which, I assume, means that REV05 was setup correctly. But the LOOKUP formula for Unit Price % is item that's getting the error.
Thank you for helping.0