Question in L1 Modelbuilding exam has same Role name as Department name.

krishnadbr

Hi,

 

Please can some one help me on how to do this as Department as well as Role name have same name Executive and same code Ex in them.

How will data flow in to the module correctly in this case.

 

 

Roles list data is 

Role	Parent	Code
Executive	All Roles	EX
Senior Director	All Roles	SD
Director	All Roles	D
Senior Manager	All Roles	SM
Manager	All Roles	M
Team Leader	All Roles	TL
Staff Member	All Roles	S

and 

Dept Code	Dept Name
SA	Sales
PR	Production
EX	Executive
FN	Finance
HR	Human Resources

 

Pivot view of Employee drivers by role is as below.

 

I got confused and was struck in this. There is no common dimension between source and target in this case. Got the following 2 questions wrong due to this.

Please can someone help me in solving this. 

 

Thanks,

Balarama Krishna

BrunoRodriguez

Hello @krishnadbr ,

 

You have provided the detailed information about the lists, but not about the modules we are going to be correlating, and need to have a common dimensionality.

 

As you well know, you have been required to provide the bonus for each employee depending upon the Employee's role and department. 

 

• EMP03 provides you the information by role and department, but is not connected with each employee.
• SYS08 has teach employee´s department and role, but does not have the salary.

If you think about the LOOKUP function (X[LOOKUP:Y1, LOOKUP:Y2]), the X represents the source module - what you are looking for (Bonus in this case)- while the Y corresponds with the correlations you want to establish (Role and department).

 

I would encourage you to read the following, written by @AlejandroGomez :

https://community.anaplan.com/t5/Anaplan-Platform/Lookup-Sum-and-Textlist-Cheat-Sheet/td-p/53085

 

Have a go at it and come back if you still do not manage to resolve it to compare answers!