Sunday, March 25, 2012

Analysis Servicees 2000 Limits

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,
-TroyTroy, its true what youre collegue says, but the number of dimension is
wrong. You can have 128 dimensions per cube.
HTH
Pablo Mugica
"Troy Jerkins" <tjerkins@.alltel.net> wrote in message
news:%23Jk8Rak3FHA.2676@.TK2MSFTNGP15.phx.gbl...
>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
>|||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
"Pablo Mugica" <PSM@.x.com> wrote in message
news:OLog0rk3FHA.2552@.TK2MSFTNGP10.phx.gbl...
> Troy, its true what youre collegue says, but the number of dimension is
> wrong. You can have 128 dimensions per cube.
> HTH
> Pablo Mugica
>
> "Troy Jerkins" <tjerkins@.alltel.net> wrote in message
> news:%23Jk8Rak3FHA.2676@.TK2MSFTNGP15.phx.gbl...
>|||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.
--
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.
"Troy Jerkins" <tjerkins@.alltel.net> wrote in message
news:%23Jk8Rak3FHA.2676@.TK2MSFTNGP15.phx.gbl...
>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
>|||Troy, as Dave says, the limitation is that you can have 64k member per
parent in AS2K and its 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
"Troy Jerkins" <tjerkins@.alltel.net> wrote in message
news:OdnfLxk3FHA.2676@.TK2MSFTNGP15.phx.gbl...
> 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
> "Pablo Mugica" <PSM@.x.com> wrote in message
> news:OLog0rk3FHA.2552@.TK2MSFTNGP10.phx.gbl...
>

No comments:

Post a Comment