Forum Discussion

Billiam864's avatar
Billiam864
Regular Visitor
2 years ago

How can I adjust data model to avoid triangular relationship

  Hi - Data model question...   I have a fact table of usage/activity data containing the user, date, and location of use.  I have dimension tables for location, date, and user details.   ...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
2 years ago

Billiam864 Get rid of the bi-directional relationship between TableDNA and TableWorkDayRoster. You could then potentially make the dimension relationships between your dimensions and fact tables bi-directional. If you have some problem that this configuration won't solve, solve it using measures.

Billiam864's avatar
Billiam864
Regular Visitor
2 years ago

Greg_Deckler; 

 

Thanks Greg for the response. As directed, I adjusted the dimensions to be bidirectional to the Fact table and not connect to each other...  however now the dimensions don't talk to each other... so for example I cannot count users by location.   Not all locations or users necessary show up in fact table,  so I don't believe communicating through that as a medium will work... unless I'm misunderstanding your suggestion?

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Billiam864 I don't know specifically what visualizations/calculations you are having problems with. But you can form relationships between your dimension tables via measures, for example. This would be a lot easier with sample data and expected results.

    • Billiam864's avatar
      Billiam864
      Regular Visitor
      2 years ago

      Greg_Deckler 

      Thanks Greg, I've tried to attach an excel file to help, but appear not allowed.  Photos are provided instead.   I unfortunately cannot attach BI data (due to scale and sensitivity).  There are 100's of various visuals across many dashboards connected to this data, so I'm trying hard to focus on the core data model, as opposed to getting lost in the weeds.  Does the excel help?