I have a question and I hope there is a simple solution again.
For my dashboard, I want to load 2 dimensions/tables.
First dimension/table: staff data (Name, Employee-ID, e-mail, department, ManagersName) Second dimension/table: staff costs (Employee-ID, date, salary, payroll taxes etc.)
Since I do create this dashboard just for one specific manager (e.g. Adam Johnson), I am loading the first dimension just for his employees:
load * where match(ManagersName, 'Adam Johnson'). Until here everything is fine.
Now I try to load the second dimension/table - but the problem is that I get staff costs for the whole company, but I just want staff costs to be loaded for employees of Adam Johnson.
So I am looking for a script statement which says: Load * from dimension staff costs where employee-ID is a ID where Manager Name = Adam Johnson.
Maybe I have to use LET-statement? I know how to restrict data-load for the "current" table, but I dont know how to make a restriction which needs to be connected to another dimension/table.
Hope there is a easy solution for my problem 🙂
Have a nice day, Jakob
Edit: the 2nd table doesn't contain the field "ManagersName"
