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

vaibhavthakkar01
Occasional Contributor

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

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]

4 REPLIES 4
Bahman.khalaj@anca.ocm
Occasional Contributor

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

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

vaibhavthakkar01
Occasional Contributor

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

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

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

what was the error, I am having the same issues
vaibhavthakkar01
Occasional Contributor

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

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