Forum Discussion
danielPrieto
Advocate I
Advocate IRelationships with bridge tables
Hi, I have a data model like this: I have a Fact Table (UserEvaluation) and some dimensions (User, Group and Client). The relation between Group and User y m:n so we also have a b...
v-danhe-msft
Microsoft Employee
Microsoft EmployeeHi danielPrieto,
Based on my test, you could try to modify the relationship between the 'User' table and 'BridgeUserGroup' table:
Result:
Regards,
Daniel He
danielPrietoAdvocate I
Advocate IHi v-danhe-msft
As I said before, this is not a real possibility. In the real case, we have hundreds of clients and thousands of groups so when I filter a client I also need to see ONLY their groups. In your proposal when filtering by Client_2 all the groups appear but Group_1 belongs to Client_1 so it should not be displayed.
In addition, the relationship between User and BridgeUserTable should be in the opposite direction since a user could belong to several groups, that is:
In summary, I need that when filtering a client:
- Your users are filtered.
- Your groups are filtered and, therefore, you can then filter the users of these client by one of their groups.
Regards,
Daniel
- danielPrieto
Any idea for this problem?