I'm having problems with very poor response time when users query our
cubes and I thought I'd make a posting here and seek recommendations of
others who have had similar issues. We have a fairly large cube with 55
partitions- processed size of 3GB and about 30 dimensions, 30 measures
and 160M rows. Most dimensions are single level dimensions with less
than 50 members. Our hardware setup is a Quad processor box with 4GB
RAM and RAID 5 storage. As we have SQL Server and As sharing the same
box, we have not enabled the 3GB switch.

We have tried warming up the cubes by executing MDX of the common
queries so that there is a better response time when users first query
the cubes. We have also used the partition aggregation utility to put
in aggregations across the big and commonly used dimensions. But, none
of these have contributed in significant improvements to query response
time. The storage design wizard maxes out at about 10% performance
gain!

Any ideas...?