I have multiple links to an Employee table in my Data Source View for a
Project dimension (i.e. Account Manager, Project Director, Project Manager,
etc...)

When I connect it all up in the Dimension Structure tabe in VS and create a
hierarchy (i.e. ProjectDescritpion-> Project Director -> Account Manager ->
Project Manager) I only see the Project Director in all three spots...so the
Project Director shows up where I excpect to see the Account Manager and the
Project Manager.

The relationships are all set correctly and the data is correct.

Do I need to create a SQL Server View that joins Project to AccountManager,
ProjectDirector, and ProjectManager using surrogate keys, rather than have
joins in the Data Source View or should this work?

"Scott" wrote: