Level 1 Model Building : Add Formulas to REV05 Price Growth Rates Staging Module

[vaibhavthakkar01]

I have been creating the model exactly as per the instructions and training material. However, I am getting the following error in lesson 9 adding formulas to REV05 Price Growth Rates Staging Module. 

ERROR : Dimension of mapping used for lookup doesn't match any dimension of the result

FORMULA : 'REV04 Price Growth Rates'.Unit Price %[LOOKUP: 'SYS04 Location Details'.Country, LOOKUP: 'SYS06 Product Details'.Product Family]

[Bahman.khalaj@anca.ocm]

Check if in your module there is a space between "Price" and "%" , if not, add. 

[vaibhavthakkar01 · Accepted solution]

Thank You.. There was some other issue with the Mapping which was throwing the error.

[KARASAGE]

what was the error, I am having the same issues

[vaibhavthakkar01]

Hi,

I don't  remember the what the error was, its been months now since I was stuck on that. However, I can help you with the formulas that I have used, you can check those with your formula and rectify the error.

Unit Price % - 'REV04 Price Growth Rates'.Unit Price %[LOOKUP: 'SYS04 Location Details'.Country, LOOKUP: 'SYS06 Product Details'.Product Family]

Unit Cost 5 - 'REV04 Price Growth Rates'.Unit Cost %[LOOKUP: 'SYS04 Location Details'.Country, LOOKUP: 'SYS06 Product Details'.Product Family]

Regards,

Vaibhav