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

krishnadbr
Contributor

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

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.

krishnadbr_1-1632843978992.png

 

krishnadbr_0-1632843939562.png

 

Roles list data is 

RoleParentCode 
ExecutiveAll RolesEX 
Senior DirectorAll RolesSD 
DirectorAll RolesD 
Senior ManagerAll RolesSM 
ManagerAll RolesM 
Team LeaderAll RolesTL 
Staff MemberAll RolesS 

and 

Dept CodeDept Name
SASales
PRProduction
EXExecutive
FNFinance
HRHuman Resources

 

Pivot view of Employee drivers by role is as below.

krishnadbr_2-1632844283183.png

 

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

1 ACCEPTED SOLUTION

Accepted Solutions
Brunra
Contributor

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

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!

Best,
Bruno Rodriguez

View solution in original post

3 REPLIES 3
Brunra
Contributor

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

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!

Best,
Bruno Rodriguez

View solution in original post

krishnadbr
Contributor

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

@Brunra 

I am still brain storming on this. Yesterday I spent over 1 hr for applying the formula LOOKUP in same lines as you mentioned. 

I tried the following even now and still not able to crack this.

 

krishnadbr_1-1632847223225.png

 

 

IF Employed? THEN Salary *'Emp03 Employee by Role'.Bonus % [LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'E3 New Role'.All Roles ] ELSE 0

 

I got the following error.

krishnadbr_0-1632847116568.png

I also tried to pivot my EMP03 in all possible ways and tried this yesterday. 

 

Please help me.

 

Thanks,
Balarama Krishna

krishnadbr
Contributor

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

@Brunra 

Also tried this.

krishnadbr_0-1632847597304.png

I am not able to add E2 as top level for E3 As I am getting the following error.

krishnadbr_1-1632847720497.png

 

Please can you help me with this. Totally confused as E3 has executive EX under role context and E1 has Executive Ex as Department.

 

Thanks,
Balarama Krishna