I have a SSAS2005 cube with two large dimension in excess of one million
members. Each of this dimensions have several attributes, some having as
little as two members.

When just exploring the dimension (not slicing) through the UI (Proclarity
6.1 and Excel 2003) it takes several minutes just to see the members of that
attribute. This is the case throughout the entire dimension and attributes.
It'll take five minutes just to see 'Yes' and 'No' under the smaller
attributes of the large dimensions.

Any ideas why this is happening or what can be done to prevent it?

Maybe it is trying to load the large dimension before you could see its
attribute members? Why don't you use profiler to see what is going on behind
the scene?

"Jesse O." wrote:

Did that, pulled out the SELECT it was running.

It's an aggregation issue. I didn't think aggregations would affect the
exploration of the dimension...but it has to scan all the partitions as
well. I thought it would only have th scan the dimension files.

Is this a correct assumption?

SELECT { SUBSET( ADDCALCULATEDMEMBERS( { [Sales].[Business Unit to Ad].[All
Business Unit to Ad].CHILDREN }), 0, 200 ) } PROPERTIES PARENT_UNIQUE_NAME,
MEMBER_TYPE ON COLUMNS

FROM [Sales]


"yongli" <yongli (AT) discussions (DOT) microsoft.com> wrote

Cannot see how the MDX query was related. Maybe it was something in
proclarity that triggered this?

"Jesse O." wrote: