Forum Discussion
Table relationship causes severe performance drop
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
Hi KayceVC
Is it necessary for that Both relationship from Month to Date table? I find the Both relationship in general more trouble than it's worth and I have only used it in a few specific situations.
Try setting it to Single and see what that is like.
Hi gooranga1
The relationship is currently Single direction from Tickets to Dates, the image may have just been overlapped a bit making it hard to see.
If this is a memory issue, I'm not sure what to do. Unfortunately I have to have this relationship for my data report properly. I've become highly restrictive in the reports to limit the amount of data in the tables, so this report is fairly small compared to others I have that function with no issues. That's why this is so puzzling.
hi KayceVC
The issue is not the Tickets --> Dates relationship but the Dates --> Month relationship.
See highlighed tables and relationship.