Forum Discussion
Relationships between Fact tables
I'm looking for a bit of advise on how to structure a model that seems, logically, to have multiple fact tables. Table one: Tasks (most granular level of detail) Table two: Work Orders (which ca...
Hi - just thought I'd bump this up to see if anyone has any further advice as I'm still a bit stuck.
In terms of how I've currently structured the data, here is a very simplified version of the Data View:
Everywhere I read tells me this isn't the right thing to do, having these 4 fact tables directly related to each other, but I can't work out how else to do it other than create a giant fact table - which I have tried, but performance of measures is hugely affected as I'm having to use DISTINCTCOUNT rather than COUNTROWS.