Level 1 Model Building Exam - Model Building Activity 6
I have been trying to work through Model Building Activity level 6 and cannot seem to understand why my lookup formula is off. I am trying to add a formula to REP04 that shows Total Salary expenses by Region and Role. The formula I am using is 'EMP02 Employee Expenses'.Salary[Lookup: 'SYS08 Employee Details'.Region, Lookup:'SYS08 Employee Details'.Role] but it receives an error.
How I understand it is that 'REP04 Employee Expense Summary'.Salary is my target and 'EMP02 Employee Espenses'.Salary' is my source module. Because EMP02 does not contain Region and Role I need a mapping module/s to achieve my goal. I am trying to use 'SYS08 Employee Details'.Region and 'SYS08 Employee Details'.Role for mapping but receive an error. What am I missing? Do I need to be using a different module? If more details are needed please let me know. Thanks for any help!
Error message: Format of mapping used for lookup doesn't match any dimension of the source
I have set up formula for Salary without having a problem. But I am facing with the problem with finding correct formula for other line items in this model like "Bonus", "Car Costs", Phone Costs" and "Medical Benefit".
Lookup function does not work in this module because of dimensions mismatch. But SUM function does not work also.