Forum Discussion
How can I adjust data model to avoid triangular relationship
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.
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?
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.
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?
