I select multilple dimensions, for instance [dim 1].[atrr hier].allmembers * [dim 2].[dim attr].allmembers ..*[dim 3].[dim attr].[dim 8] and a measure, which is linked to all dimensions .
Since 2 dimensions have grown larger lately, and given large number of dimensions queried, performance degrade has grown to unacceptable levels.
What is the best way to select only these members which are actually relevant? I'm well known with the filter statement but do we have alternatives?
Business Intelligence professional
View Complete Post