Forum Discussion
Relationships help
Hi all,
need help as Im loosing my hair here 🙂
I have calendar table (dimCalendar) which Im using to filter other tables (employees, Remaris export, budget ).
Primary/Foreign key is Date.
Ive created few measures which feed data from Remaris table only.
My goal is to create matrix table which will display measures results based on Worker list from Employees table.
How to do it?
For now, I can only display values by Calendar (days,weeks,months,etc), see below
If I replace Dates by Employees list, im getting incorrect results, see below
Ive tried to change all relationships to both-directional, but no luck.
Dont know what Im doing wrong....
If you want to break down the data from remaris by employee then you need a column in the remaris table which you can link to from the dim employee details table in a one-to-many single direction relationship.
Don't change the relationships to both directions, single direction is correct.
2 Replies
If you want to break down the data from remaris by employee then you need a column in the remaris table which you can link to from the dim employee details table in a one-to-many single direction relationship.
Don't change the relationships to both directions, single direction is correct.
johnt75 The only possible could be using Date column, the problem is that I have multiple dates in both tables (Remaris and Employees) meaning I would have to use many-to-many relationship (which is not a good idea).
Dont have any other column which I could use to link these 2 tables.