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

Highlighted
New Contributor

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

Hi Experts,

Please help on the below mentioned issue while adding formula for Bonus, Car, Phone costs & Medical costs to the EMP02 Module.

 
Bonus IF Employed? THEN Salary * 'EMP01 Employee Drivers'.Bonus %[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Country] ELSE 0
Car costs IF Employed? THEN 'EMP01 Employee Drivers'.Car Allowance[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Country] ELSE 0
Phone costs IF Employed? THEN 'EMP01 Employee Drivers'.Phone Allowance[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Country] ELSE 0
Medical costs IF Employed? THEN 'EMP01 Employee Drivers'.Medical Benefits[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Country] ELSE 0

Thanks Error.JPG

16 REPLIES 16
Highlighted
Certified Master Anaplanner

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

Hi @rahulharjai ,

 

This error occurs usually when you have mismatch of the dimensions. 

 

In your case the formula for Bonus, Car, Phone costs & Medical costs are currently referred from EMP01 Employee Drivers module(dimensions : G2 Country and E1 Departments; that's the reason the lookup is done to match the country and department.)

 

 

Hope this helps.

 

Jitendra

Highlighted
New Contributor

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

@Jitendra.Vishnolia

I had tried the approach shared, but facing an issue related to not recognized line item. Please find the attached screenshot.

 

 

error1.JPG

Highlighted
Certified Master Anaplanner

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

@rahulharjai 

 

 My apologies for the misunderstanding.

 

Please check the format of the line item Department of SYS08 Employee Details module it should be #E2 Employees, and try again with the initial formula.

 

Highlighted
New Contributor

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

Hi @Jitendra.Vishnolia 

 

Thank you for your help !

 

I tried to change the format of department list item of Sys08 Module from E1 Departments to #E2 Employees but facing an below mentioned issue. Please help.

 

Issue :

 

Thissys08.JPG

 

Blueprint View:

 

 

earlierSys08.JPG

 

Thanks & Regards,

Highlighted
Certified Master Anaplanner

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

@rahulharjai 

 

Can you share the Blueprint view of EMP 02 Employee Expenses Module as well.

Highlighted
New Contributor

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

@Jitendra.Vishnolia ,

 

Yes, Sure. Please find the attached blueprint for EMP02 Module.

 

Emp02 Module.JPG

Highlighted
Master Anaplanner/Community Boss

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

@rahulharjai 

I just wanted to add one point that @Jitendra.Vishnolia brought up which is absolutely correct and might be helpful to you as you continue to use LOOKUP, SUM, and SELECT.

For me when I started using these functions, it was helpful to think of modules as tables and the line items that I wanted to use to join as the primary or foreign keys. 

So like any SQL join, you have to join the tables by a common key with the same format. The same is true in Anaplan.

If I want to join two modules together using formulas, i need to have a common line item in the same format. 

 

Also , when you're ready, read the best-practice post on DISCO by @DavidSmith . This is by far one of the most important documents written on this subject. This will also help you set up system modules which contain all the "keys" and properties of your lists.

 

I'm really glad you asked this question. It took me a very long time to get this figured out so I hope you'll continue to ask the Community anytime you get challenged by these functions. Between the best-practice posts and this Community Site is where I learned pretty much everything I know about Anaplan.


Jared Dolich
Highlighted
New Contributor

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

Hi 

 

@JaredDolich@usman.zia

 

Thank you for sharing the valuable insights !

 

Here I am referencing the instructions provided in manual to create the EMP02 module and its formulas as it is provided by Academy content team and facing issue in that. Is there any typo error or missing step in instructions ?

 

instructions.JPG

 

Thanks & Regards,

Rahul Harjai

Highlighted
Certified Master Anaplanner

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

@rahulharjai ,

 

EMP02 seems to be fine, can you also share EMP01 Module Blueprint view.