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

rahulharjai
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
usman.zia
Master Anaplanner/Community Boss

@rahulharjai - one of the formulas you mentioned doesn't work because the result is a true or false format so that needs to be changed.

Try to break down what you're trying to achieve in to small steps.

Then you can think about the relationships you need to make as mentioned by @JaredDolich by using either sum or lookup or select (try to avoid select where possible),

Then you can build the solution. 

 

I hope this helps!

 

Thanks,

 

Usman

rahulharjai
New Contributor

Hi @Jitendra.Vishnolia ,

 

Apologies for delay in response.

 

Please find the attached EMP01 Module Blueprint View.

 

EMP01.JPG

 

Thanks & Regards,

Rahul Harjai

rahulharjai
New Contributor

@Jitendra.Vishnolia 

 

Please find the attached screenshot for EMP02 & EMP01 Module.Error11.JPG

 

EMP01.JPG

 

Thanks & Regards,

Jitendra.Vishnolia
Certified Master Anaplanner

Hi @rahulharjai ,

 

You are using #E2 Employees: Active ?  as a LIST  not a subset of #E2 Employees. Please find the screenshot of Pivot view of EMP02 module and observe the difference.

 
rahulharjai
New Contributor

@Jitendra.Vishnolia 

 

Thank you Jitendra !

Jitendra.Vishnolia
Certified Master Anaplanner

Picture1.png

JaredDolich
Moderator

@rahulharjai 

Your so close!

Unfortunately, we can't give direct answers on the certifications but let me try to point you in the right direction.

In your SYS08 module, you need to check the format of your department line item.

 

Remember, ITEM(department) results in a list formatted line item for department. Parent(item(department)) will give you a list formatted line item of the list that is above department.

Experiment with different formulas and/or formats to get it right. 

The error you're getting is your best clue.

 

 


Jared Dolich