Having issues with cube query performance?
Cube query performance may stem from a number of reasons.
- The cube may not be partitioned properly
- Aggregations may have not be set properly
- The client tool may not be writing efficient MDX
- There could be some cube calculations that are causing the problem
We can help you troubleshoot your query performance problems. The first check would be to see if the first two items listed were implemented properly, since the majority of query performance problems include partitioning and aggregations.
But then we can further help you narrow in on any potential issues with the help of SQL Profiler.