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

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

neerajahuja77

I am also getting the same Dimension is used for Lookup doesn't match any dimension of the result. Can someone help