How do I add Virtual table to Report Model (dsv)?

Hi,

problem: I got "Sale" table that include Employee ID & Manager ID.

I want to connect" Employee" table twice to "Sale"

once: Sale.EmployeeID=Employee.EmployeeID

second: Sale.ManagerID=Employee.EmployeeID

how do I create a virtual table for the second connection? can't I solve it in the model layer or need to add view in the database layer?

Thanks,

Assaf

You need to open DSV in Model Designer and add new relationship with Sale.ManagerID=Employee.EmployeeID (you should already have one relship for Sale.EmployeeID=Employee.EmployeeID).

Then open the model and regen the two involved entities or create two new roles manually.