Lookup not working - dimension used for lookup doesn't match any dimension of the source

CommunityMember82902
Occasional Contributor

Lookup not working - dimension used for lookup doesn't match any dimension of the source

HI 

I have 2 line items in the same module which are both in list format using the same subset list.

I would like 1 of the line items to be completed based on the entry made in the other.

I have created a mapping module using the same subset list as for the module and the line item (see attached screen shots).

But when I try and lookup from one to the other (formula shown in attachment) using the mapping, I get the "dimension used for lookup doesn't match any dimension of the source" error.

 

Any ideas what I am doing wrong here, as I am sure I had it working like this previously, but using an older list which has now been replaced.

 

Thanks

 

1 ACCEPTED SOLUTION

Accepted Solutions
rob_marshall
Moderator

Re: Lookup not working - dimension used for lookup doesn't match any dimension of the source

@CommunityMember82902 

 

Remember how the Lookup works.  The Lookup part (the part within the [ ] ) has to be on the "outside of the house", meaning it has to be on either the Page, Column, or Rox axis.  The "measure" part is "in the house" or the actual line item you are retrieving.  This is why the lookup part has to be a list formatted line item or Time.

 

Hope this helps,

 

Rob

View solution in original post

5 REPLIES 5
rob_marshall
Moderator

Re: Lookup not working - dimension used for lookup doesn't match any dimension of the source

@CommunityMember82902 

 

Remember how the Lookup works.  The Lookup part (the part within the [ ] ) has to be on the "outside of the house", meaning it has to be on either the Page, Column, or Rox axis.  The "measure" part is "in the house" or the actual line item you are retrieving.  This is why the lookup part has to be a list formatted line item or Time.

 

Hope this helps,

 

Rob

View solution in original post

CommunityMember82902
Occasional Contributor

Re: Lookup not working - dimension used for lookup doesn't match any dimension of the source

Thanks Rob, I have just called myself all kinds of names!! 😂

 

I knew it was something simple, but my head was just stuck in trying to do it the other way.

 

Thanks for unlocking my brain!

Gary

rob_marshall
Moderator

Re: Lookup not working - dimension used for lookup doesn't match any dimension of the source

@CommunityMember82902 

 

Gary,

 

We all need unlocking at some point, it is all good.

bhubeshrana
Contributor

Re: Lookup not working - dimension used for lookup doesn't match any dimension of the source

You Don't need to use lookup function. Just reference the lineitem in other line item.

ChrisHeathcote
Community Boss

Re: Lookup not working - dimension used for lookup doesn't match any dimension of the source

Use LOOKUP when the dimension of the mapping matches the target and where the line item in the mapping bridges back to the source.

 

The line item format should match the dimension of the source and acts as the bridge from source to target.

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA