Level 1 Model : Dimension of mapping used for lookup doesn't match any dimension of the result.

Highlighted
Contributor

Re: Level 1 Model : Dimension of mapping used for lookup doesn't match any dimension of the result.

Spoiler
 

I had entered what I believed to be the correct formula, and after reading your response, I had typed the formula correctly (it matched what you listed), however, I am getting this error:

 

Invalid formula for 'EMP02 Employee Expenses'.Bonus: Automatic sum of 'EMP03 Employee Drivers by Role'.Bonus % over E3 Role hierarchy is not possible as E3 Role does not have a built-in top level

 

Any ideas would be appreciated!

Thank you!

Highlighted
New Contributor

Re: Level 1 Model : Dimension of mapping used for lookup doesn't match any dimension of the result.

Hi @Misbah 

 

Please find the attached screenshot for EMP02 Dimensions.

 

Thanks

Highlighted
Master Anaplanner/Community Boss

Re: Level 1 Model : Dimension of mapping used for lookup doesn't match any dimension of the result.

@rahulharjai 

 

Dimension seem to be matching. Can you please follow what @usman.zia has explained. I think it appears to be ordering of the instructions.

 

Thanks,

Misbah

Highlighted
New Contributor

Re: Level 1 Model : Dimension of mapping used for lookup doesn't match any dimension of the result.

@rahulharjai @Misbah Something is incorrect with the instructions. I have encountered the same exact issue.

 

From what I understand from the discussion, one possible solution is building a module titled EMP03. This step is not in the instructions and should be done on an Ad-hoc basis.

 

Contributor

Re: Level 1 Model : Dimension of mapping used for lookup doesn't match any dimension of the result.

The issue I have with the EMP02 module is that the lookups for the car, phone and medical benifits line item is not working properly because the EMP01 module does not include the time dimension.  So instead of getting a single value for these line items, I get an aggregation, for example for Sarah Engle, I get car cost of 1.8M instead of 800.  I don't know if this is addressed later in the course or not but I haven't figured out a way around it yet.  Any ideas?

Highlighted
New Contributor

Re: Level 1 Model : Dimension of mapping used for lookup doesn't match any dimension of the result.

Update: Discovered that the list used for EMP02 was a sub-list of G3 Location instead of #E2 Employees. Correcting this has corrected the dimension error, which makes sense. I'm unsure if the instructions are incorrect as I have not needed to create an additional module titled EMP03. All seems to be right.

Highlighted
New Contributor

Re: Level 1 Model : Dimension of mapping used for lookup doesn't match any dimension of the result.

@jai.kannan

Could you please provide the detailed steps so that we don't need to create an additional module titled EMP03.

Thanks