Forum Discussion
How to implement a star schema
I have two fact tables, they can't join due to a m:m relationship. I have read that a star schema design should be followed to fix this. What is the best way to add the dimension tables to my model. 1 way could be to get it directly from the oracle database my work uses but that contains a lot of steps. Is there another way I can create dimensional tables in power query using the rows and columns already present in the model.
Thanks for your time, I have managed to solve this issue I had.
8 Replies
akhaliq7 Star schemas are great but I have rarely in the real world ever seen a true star schema used in business models. They are always more complex than that. I would recommend a bridge table between your two fact tables with bi-directional relationships. Then you can add your dimensions to either fact table.
I have tried that in my case the two fact tables won't filter properly i have order_id as the key column in the bridge table but then sales person is in both fact tables but will not filter correctly in both,
unless i use sales person id as the key column in the bridge table but then order id will not be related in both tables.
