Any ideas on how to handle large levels?

I'm having performance issues when users try to add a dimension that has a
large level. I've already implemented grouping level but that does not help
with the performance when trying to access the data level.

which version of AS? (2000 or 2005)
how large is your dimension?
what do you mean by "data level"? do you talk about lowest level of the
cube?

optimize your aggregation design, partition your cube are the first steps to
do.

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

SQL 2000 requires the entire dimension be loaded into memory when referenced,
which is often slow ( or even a stop if there is not enough memory.)

SQL 2005 does not require the complete load of the dimension, but large
dimension are still slow, especially in your case when there are many members
on the same level
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC

I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.


"Jeje" wrote: