Data Flow and Fact Tables

I have several tables of facts, sales, hours, and a flow with employees and their superior. The employee can change over the course of the time of the superior, I want to know the superior at all tim...