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 brokencornets ,
It would be much better if you can tell what fields are present in all the tables.
Ideally, you should connect Dimension tables to Fact Tables in uni-directional filtering in which Dim table would filter fact table.
Example:
1. Dim Table with "JobID" should be joined with Fact table with Jobs in which you have "JobID".
2. Join Date Table to Date fields in all fact tables. Use Date Table's Date in slicers, charts, graphs, etc.
Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! |
Thanks for the advice. Are you saying I should create a 'Jobs_Dim' table holding all Job IDs which would link to both 'Jobs_Fact' and 'WO_Fact' tables?