Forum Discussion
Connect same dimensions to multiple fact tables
I have five dimension tables (lets call it DimA, DimB and so on). I am trying join them to two fact tables (Fact1 and Fact2). Dim A and Dim B are connected to Fact1 has 1 to many relationshi...
Hi acbg
I would suggest rather building 2 seperate datasets so that you can have DimA going to Fact1 and DimA going to Fact2
When trying to combine multiple fact tables with multiple dimension tables creates a lot of performance issues as well as potential issues for data to not be accurate if using many - many relationships.
Hi GilbertQ ,
So I did try that and used Treatas to ensure the filtered values are being based through so that when we filter on one dimension (DimA connected to fact1) it filters the other (DimA connected to fact2). Performance was horrible. It does not make sense to display the same column slicers from both DimA tables. Any ideas on how to filter both tables at the same time?