Forum Discussion
ambiguity between tables
Hi I don´t understand why I can not create this relationship between Proyectos and Horas Each time I try it I get tis message: In the Horas Table there is no record with proye...
It looks like a Many to Many scenario. One Employee can work for multiple projects, and one project is mady my multiple employees. So you should have a fact table between Employee and Project table to decribe the mapping for getting the working hours associated with each employee.
You can refer to the Many to Many solution white paper on sqlbi:
https://www.sqlbi.com/topics/many-to-many/
Regards,
That's the idea...
In HorasFULCRUM table I hav the relation between Empleados and Proyectos, that is, In HorasFulcrum I have the Empleados.userids and the Proyectos.IDs that represebts the hours worked by the employees in the diferente projects.
But I can not activate the relationship and I don't know why...
regards