Is there a limit on the count of rows in a dimension?
(MS Analysis Services Enterprise Ed.)

I found this quote from Mr. Pendse on Google Groups:


Strange, I could swear I once got an error message from MS AS
telling "64000 is maximum for a dimension" or something.

In any case, the number was "64000", it was a "maximum"
of something, it related to a dimension, and it was an instance
of MS AS (and not of the old OLAP Services).

I asked the original question because right now I'm modeling
SQL dimension tables (to be fed to MSAS) and I have to know
how to model them, considering I got a message above.
(Perhaps I have to introduce those dummy levels.) But right
now I can't reproduce the error/problem I had in MS AS.
Thanks for any clarification!

Any single member of a dimension cannot have more than
64,000 children.

So if you were to add say ten hierarchy levels you could
have 64,000 by the power of 10 members
1,152,921,504,606,846,976. Quite a number, but you can
have more than ten levels.

Lutz

As Lutz indicated, the limitation is not that a dimension can only have 64K
members, but that no single parent (member) in the dimension can have more
than 64K children. If you have more than 64K children per parent, you can
use the automatic grouping functionality or introduce an additional.
Personally, I think it's very hard for users to drill down on a given member
and see more than a couple of hundren children....thousands just becomes too
much for the user to absorb.

Sean


--
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.

"Lutz Morrien" <lutz.morrien (AT) _remove_ocb (DOT) com> wrote