I have a table showing absence registrations for different departments represented with an Employee number.
Then I have another table showing extra data on each Employee (and the Employee number).
Can I somehow mash those to data sources up - and what are the pitfalls?
Louise Stub Hansen You can create a cube with the two data sources, but you will need a dimension table containing just the employee number. The employee number should include a total list of all the numbers in your two data sources. If possible, you can create the dimension table as a format on one of your existing data sources and select emplyee number as the only column and choose "Rows" > "Remove duplicates at row level". So your key is a dimension table with all existing employee numbers without any duplicates.
Screenshots of remove duplicates: https://community.targit.com/hc/en-us/community/posts/360014526577-Remove-duplicates-in-data-source?page=1#community_comment_360003818757
Comments
1 comment