How to take a decision on performance.
I am looking at the performance tuning and i have observed the ratio of DBsel and DBtran is very high like in some queries its more than 400 times so i am looking at creating aggregates .
My question is that how many aggregates are okay like i want to analyze how is it going to effect my loading or maintance when i am doing it for Query performance.
i have around 40 queries on my cube and i am estimating around 24 aggregates..is it okay to have 24 aggregates or else any other solution.
thanks and regards