getting the error: "Dimension of mapping used for lookup doesn't match any dimension of the result"

aadilrafeeque
Occasional Contributor

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.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
JaredDolich
Moderator

Re: getting the error: "Dimension of mapping used for lookup doesn't match any dimension of the

@aadilrafeeque 

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. 


Jared Dolich

View solution in original post

2 REPLIES 2
JaredDolich
Moderator

Re: getting the error: "Dimension of mapping used for lookup doesn't match any dimension of the

@aadilrafeeque 

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. 


Jared Dolich

View solution in original post

aadilrafeeque
Occasional Contributor

Re: getting the error: "Dimension of mapping used for lookup doesn't match any dimension of the

@JaredDolich 

 

Thanks for correcting me. The granularity i used was not matching. I made the change you mentioned and its working now

 

Appreciate the help!!