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

Options
aadilrafeeque
aadilrafeeque Member, ALL USERS Posts: 5 Occasional Contributor
in Planning & Modeling

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.

 

 

Tagged:

Comments

  • aadilrafeeque
    aadilrafeeque Member, ALL USERS Posts: 5 Occasional Contributor

    @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!!

Categories