Question in L1 Modelbuilding exam has same Role name as Department name.
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
|Senior Director||All Roles||SD|
|Senior Manager||All Roles||SM|
|Team Leader||All Roles||TL|
|Staff Member||All Roles||S|
|Dept Code||Dept Name|
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.