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

[rahulharjai]

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 

[usman.zia]

@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]

Hi @Jitendra.Vishnolia ,

Apologies for delay in response.

Please find the attached EMP01 Module Blueprint View.

Thanks & Regards,

Rahul Harjai

[rahulharjai]

@Jitendra.Vishnolia 

Please find the attached screenshot for EMP02 & EMP01 Module.

Thanks & Regards,

[Jitendra.Vishnolia · Accepted solution]

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]

@Jitendra.Vishnolia 

Thank you Jitendra !

[Jitendra.Vishnolia]

[JaredDolich]

@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.