Error: Dimension of mapping used for lookup doesn't match any dimension of the result

Highlighted
Occasional Contributor

Error: Dimension of mapping used for lookup doesn't match any dimension of the result

Hi gurus, 

 

When building the reporting module 'REP04'(the target) I've tried to reference an existing module 'EMP03' (the source) for the calculated medical costs. REP04 has two dimensions 'Region' and 'Role' whilst EMP03 has 'Department' and 'Role', hence I tried the mapping module 'SYS08' to fill the gap. Thought it's ok but still run into 'Dimension of mapping used for lookup doesn't match any dimension of the result', any help is much appreciated. 

 

Thanks

Joanne

3 REPLIES 3
Highlighted
Certified Master Anaplanner

Re: Error: Dimension of mapping used for lookup doesn't match any dimension of the result

Hello @JoanneM 

 

You are on the right track.
Check this post, it might help you understand the root issue and arrive at the solution yourself 😊

 

https://community.anaplan.com/t5/Academy-Training/Altering-Line-Item-Formula-with-lookup/m-p/88856#M...

 

If you still have questions please let me know.

 

Good Luck

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"
Highlighted
Occasional Contributor

Re: Error: Dimension of mapping used for lookup doesn't match any dimension of the result

Hi Einas, 

Many thanks for your swift reply, I saw the quoted post and it was helpful. 

I've given it another shot but this time it throws an error: Format of mapping used for lookup doesn't match any dimension of the source. 

This is the thread of my thoughts: 

  1. My target module REP04 has region and role as two dimensions.
  2. I've referenced a different source this time the EMP01 which uses G2 Country and Department as dimensions, it also has medical costs data.
  3. I've also had another module EP03 Employee Drivers by Role which is dimensioned by Department and Role, as part of the example data was imported via csv file. 
  4. So technically what I'm trying to do is to join EMP01 with EP03 on department, based on the result set to aggregate them into region vs. role so to populate my target module REP04. 

Not sure whether I'm still on the right track? 

 

Cheers

Joanne

 

 

JoanneM_0-1604330314561.png

 

Highlighted
Occasional Contributor

Re: Error: Dimension of mapping used for lookup doesn't match any dimension of the result

@einas.ibrahim No worries, I figured it out I've got EMP02 calculated at good granular level so I just need to sum them up together by two dimensions in my target module. 

 

Problem is solved. 🙂