October 12, 2021
July 16, 2010
You haven't said why you're unable to create the relationship, but I'd say it's giving you a duplicates error. If so, you need to create another dimension table containing a unique list of your employee IDs. You then create the relationship between the two fact tables (Active and Term) and the new Employee ID dimension table.
IMPORTANT: when you build your PivotTables you use the Employee ID field from the dimension table in your PivotTable row/column lables.