I have 'employee' table which has EmployeeID and SupervisorID (self-join) and I join the table to fact table using Username field as the fact table doesn't have EmployeeID.
I would like to build Employee hierarchy and I have two questions:
1) What is the standard way of doing that? I presume this is rather very common.
2) How can build hierarchy so it appear on multiple levels.... like Tree view?
Many thanks in advance