Microsoft Analysis Services
Dimensions - Qty 10
Two of the dimensions contains 500 values.
The remainder have between 5 and 15 values.
Only one measure.

This cube is rather slow. It was much faster with only one dimension
at 500 values. I understand that adding a second large dimension may
bogue it down.

Is two large dimensions not appropriate? What is the typical number
of dimensions, along with the size of those dimensions? Also, what
one performance fix would you anticipate making the largest
difference?

Thank you!