Forum Discussion
Solved
Table relationship causes severe performance drop
I have been working to optimize an existing report in our company. I trimmed the largest table down to around 150k rows by adding a date filter. The total report has 14 tables with 11 of them having ...
KayceVC -
Regarding the snowflaking - There are 3 tables that could be removed and incorporated into their respective dimension tables:
Months -> Dates (can create a M-to-M relationship with Agreement Revenue)
Staff Teams -> Staff
Customer Teams -> Companies
you have circular relationships betwen tables which is causing poor performance. tryy to avoid it
Thank you both! Sorry it took me so long to circle back to this, I got assigned tasks with a higher priority and was just able to test these solutions yesterday. I don't know how I overlooked the relationship between Dates and Months as causing the issue for so long, but as soon as I removed it and updated the links and measures, the report performs perfectly again!