When browsing dimension data in SQL Server 2000 Analysis Manager for a large dimension, not all of the dimension members are displayed - instead it displays "More members exist than can be displayed" as the last displayed node. Are we hitting a limit with DSO or AS itself?

Hopefully you aren't hitting any limits of AS.

Analysis Services can handle upto 2^31-1 = 2,147,483,647
maximum Members in a dimension.

But the Analysis Services Manager shows only about first
1000 members or so. (as sample...)

Incase you are having any reporting tool or you have
programmed to access the Data in Dimension, you will get
all the Members from your dimension.

Check out the SQL BOL (Analysis Services,limits) to see
the various Size Limitations of AS 2000.

HTH.
Cheers,
Sanka



members are displayed - instead it displays "More members
exist than can be displayed" as the last displayed node.
Are we hitting a limit with DSO or AS itself?

You're not hitting a limitation with Analysis Services. It's a limitation
in the Analysis Manager browser. If you can process the dimension, you can
rest assured that the dimension exists in it's entirety. The Analysis
Manager browser is really just there to help administrators build AS
databases, cubes, etc....it's not really designed to be a full-fledged
client application so it does have some limitations. It also has some
advantages though, in that it allows you to browse a dimension without it
existing in a cube in many cases.


--
Sean

--
Sean Boon
SQL Server BI Product Unit

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.



"Sanka" <loonysan (AT) mailcity (DOT) com> wrote