The performance of cube with large dimension table

[huawang]

hi,  I found that if a dimension of the cube has a large number of candidates, 
the query will be very slow. Is there any solution to this condition?