I have a dimension which contains two tables. The two tables have two
relations between them, like this:

Plan
Employee
------ --------------
ManagerId (referencing Employee.EmployeeId) EmployeeId
EmployeeId (referencing Employee.EmployeeId) Name

I would like to show the name for the both employee in my dimension. HGow is
that possible? Right now do they both show the same.

Thanks

Henrik Skak Pedersen