Forum Discussion
Solved
Data Modeling w/ Multiple Facts
Hello, I am a bit stuck and need some guidance with a data modeling issue I am facing. Recently, users wanted to add an additional table to support some reporting efforts and that table when bui...
Just as an update. I found my issue. I no longer need a bridge table because I corrected some data in our source. What was happening was a specific user kept using a placeholder ID that was the same and I told them that they could not do that. Once that data was corrected and removed the relationship between the two tables worked as intended.
You're on the right track. You do want to create a "projects" dimension table that contains a distinct list of all the project ID's from both fact tables. Then you can create a 1:* relationship from this dimension to both fact tables.