More than one dimension based on a single table.

[LeroySalih]

Hi,
My fact table has two fields, Employee1Id and Employee2Id. I also have a single Employee Table which stores employee information in a hierachy.

I can set up the first Parent-Child dimension on employee1 OK, but not the second employee field.

Does anyione have any ideas?

Thanks,

Leroy.