I got a query which is giving performance issue.
User is complaining that when they first run the query in the morn then report is giving time out error.But I never came across this error.
Thus only thing which comes to my mind is mostly number of user excuteing the report is more and thus report is giving time out error.
Agg are already bulit on cube.
Can anybody suggest on the issue.