| Author |
Maximum number of distinct childen in a Dimension Level?
|
|
| SmartGuy 2005-12-20, 8:25 pm |
| So we AS 2000 we have a limit of 64K distinct children in a dimension level -
what is the new limit in SSAS 2005 64-bit?
--
SmartGuy
| |
|
| near nothing!!!
the new dimension system allow near unlimited members for an attribute..
"SmartGuy" < SmartGuy@discussions
.microsoft.com> wrote in message
news:462804AE-1C86-4598-8986- 3253FF9E5336@microso
ft.com...
> So we AS 2000 we have a limit of 64K distinct children in a dimension
> level -
> what is the new limit in SSAS 2005 64-bit?
> --
> SmartGuy
| |
| Dave Wickert [MSFT] 2005-12-21, 3:24 am |
| Actually the limit is 2**32 or roughly 2 billion. Just about all of the
limits in AS2K have been raised to 32-bit signed integers. So for all
intended purposes it is unlimited.
--
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.
"Jéjé" < willgart@BBBhotmailA
AA.com> wrote in message
news:%23QVUl8bBGHA.3292@TK2MSFTNGP09.phx.gbl...
> near nothing!!!
>
> the new dimension system allow near unlimited members for an attribute..
>
> "SmartGuy" < SmartGuy@discussions
.microsoft.com> wrote in message
> news:462804AE-1C86-4598-8986- 3253FF9E5336@microso
ft.com...
>
>
|
|
|
|