Analysis Servicees 2000 Limits

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Troy Jerkins - 31 Oct 2005 19:11 GMT

I have a (respected) collegue that seems to be certain that a limitation of
a diminsion is 65,000
rows. I have not been able to confirm this anywhere. Only that the number of
Dimensions per cube
is limited to 65,535.

Can anyone confirm if there is any limit to the number of dimension rows for
any of the storage models (MOLAP, ROLAP, HOLAP)?

Thanks,

-Troy

Reply to this Message

Pablo Mugica - 31 Oct 2005 19:42 GMT

Troy, it´s true what youre collegue says, but the number of dimension is
wrong. You can have 128 dimensions per cube.

HTH

Pablo Mugica

>I have a (respected) collegue that seems to be certain that a limitation of
>a diminsion is 65,000
[quoted text clipped - 8 lines]
>
> -Troy

Reply to this Message

Troy Jerkins - 31 Oct 2005 19:52 GMT

Thanks for the confirmation. Has this limitation been lifted in AS 2005? I
can't find ANYTHING spec-wise on capacity other than the the 2GB backup
limit has been lifted.

-Troy

> Troy, it´s true what youre collegue says, but the number of dimension is
> wrong. You can have 128 dimensions per cube.
[quoted text clipped - 15 lines]
>>
>> -Troy

Reply to this Message

Pablo Mugica - 31 Oct 2005 21:11 GMT

Troy, as Dave says, the limitation is that you can have 64k member per
parent in AS2K and it´s not a limit anymore in SSAS 2005.
About the limit please refer to "Specifications and Limits" in the AS2K
Books On Line and to http://blogs.msdn.com/bi_systems/articles/187740.aspx
about SSAS 2005.
Regards,

Pablo Mugica

> Thanks for the confirmation. Has this limitation been lifted in AS 2005? I
> can't find ANYTHING spec-wise on capacity other than the the 2GB backup
[quoted text clipped - 21 lines]
>>>
>>> -Troy

Reply to this Message

Dave Wickert [MSFT] - 31 Oct 2005 20:04 GMT

Totally in-correct. You can have dimensions with millions and millions of
members.

The limitation (lifted in AS2K5) is that a parent is limited to only 64000
children.
If your dimension has multiple levels that it is only unusual cases where
this comes into play. Where it does, you can use automatic grouping to add
an intermediate level kind of like a phone book (A thru J, K thru S, T thru
Z) -- AS automatically detects and generates the thresholds for the
intermediate members.

Signature

Dave Wickert [MSFT]
dwickert@online.microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

>I have a (respected) collegue that seems to be certain that a limitation of
>a diminsion is 65,000
[quoted text clipped - 8 lines]
>
> -Troy

Reply to this Message