Forum Discussion

kintela's avatar
kintela
Helper II
9 years ago

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...
Need Help
kintela's avatar
kintela
Helper II
9 years ago

But the relationship betewwen Empleados and Proyectos says that one Employee can be group leader of many Projects but one employee that is not group leader of any proyect can work hours in any project.

 

So If I want to know the name of the emoployee that has Hours in the Horas table through his userId I only could get the hours of group leaders throug the filed "jefeGrupo/group leader". No?

 

 

 

 

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
9 years ago

kintela

 

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,

  • kintela's avatar
    kintela
    Helper II
    9 years ago

    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