Forum Discussion
richard-powerbi
Post Patron
Post PatronFilter dimension tables in Star schema?
First I had a flat table and when I filtered in the filters pane, it would also filter out the other 'dimension columns'. Now I made it into a star schema and when I filter 1 dimension in the filter...
richard-powerbiPost Patron
Post PatronHi Anonymous
I know this is a solution, but I always read you should avoid bidirectional relationships for performance and aggregation risks. This way I'll get many bidirectional relationships. Is there another solution? Or how can I check if it messes up my aggregations? I know it happens if there is more than one path to follow, but this is very hard to analyze in a big model....
I know this is a solution, but I always read you should avoid bidirectional relationships for performance and aggregation risks. This way I'll get many bidirectional relationships. Is there another solution? Or how can I check if it messes up my aggregations? I know it happens if there is more than one path to follow, but this is very hard to analyze in a big model....
I don't think so unless you make some common table that associates all the foreign keys from those all tables.
BR,
DR
- richard-powerbiYea that might be a better solution. I'll accept it as a solution once I've implemented it.
v-lid-msftCommunity Support
Hi richard-powerbi ,
How about the result after you follow Anonymous 's suggestions ?Could you please provide more details about it If it doesn't meet your requirement?
Best regards,- richard-powerbi
I still have to implement this, when I have no other questions I'll accept it as a solution.
- richard-powerbi
So I'm trying to implement this now. Would I have to add the table with only the keys between the fact tables and dimension tables? Or on top of the dimension tables? Could anyone sketch this?