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

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

Anaplan_lookup_query_120002.docx

Accepted answers

rob_marshall

@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

All comments

rob_marshall

@CommunityMember82902

Hope this helps,

Rob

bhubeshrana

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

ChrisAHeathcote

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.

CommunityMember82902

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

@CommunityMember82902

Gary,

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

Quick Links

Can you help?

Unanswered questions

ADO File Upload - Semicolon Delimiter
Hi, Based on the regional settings, my default delimiter/separator for CSV files is a Semicolon. In the classic way of uploading a csv file, I was able to select the delimiter. When using ADO, I don't have the option to select a delimiter. Uploading a Semicolon delimited file returns an error, or an upload with only one…
Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…