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

Highlighted
Master Anaplanner/Community Boss

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

@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

Highlighted
New Contributor

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

Hi @Jitendra.Vishnolia ,

 

Apologies for delay in response.

 

Please find the attached EMP01 Module Blueprint View.

 

EMP01.JPG

 

Thanks & Regards,

Rahul Harjai

Highlighted
New Contributor

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

@Jitendra.Vishnolia 

 

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

 

EMP01.JPG

 

Thanks & Regards,

Highlighted
Certified Master Anaplanner

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

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.

 
Highlighted
New Contributor

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

@Jitendra.Vishnolia 

 

Thank you Jitendra !

Highlighted
Certified Master Anaplanner

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

Picture1.png

Highlighted
Master Anaplanner/Community Boss

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

@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