Forum Discussion

jimbob2285's avatar
jimbob2285
Advocate IV
9 months ago
Solved

Relationship Conflict

Hi   I feel like this is a very basic query, but I'm really struggling with it.  Could someone please help?   I have three tables: Fact_Sales, Fact_Activity & Dim_Users.  So that I can filter bot...
Need Help
  • MFelix's avatar
    MFelix
    9 months ago

    Hi jimbob2285 ,

     

    This is hapenning because there is already a link between both tables using the Dim Users, in this case you need to create another dimension table with the Sales ID, alongside with all the fields you would need to use as a filter for those two tables.

     

    Don't know what is the purpose of the filtering between those two tables but I suggest that you revise if you can combine both table into one, not sure what how the rest of your model looks like but can be an option.

MFelix's avatar
MFelix
Super User
9 months ago

Hi jimbob2285 ,

 

This is hapenning because there is already a link between both tables using the Dim Users, in this case you need to create another dimension table with the Sales ID, alongside with all the fields you would need to use as a filter for those two tables.

 

Don't know what is the purpose of the filtering between those two tables but I suggest that you revise if you can combine both table into one, not sure what how the rest of your model looks like but can be an option.