Someone told me that the largest number of dimensions that can be created in Analysis Server is 12 or 14. I would like to ask if this is correct. We use MS SQL 2000 32-bit version. Is there a upper limit of number of dimensions or number of members can be created in Analysis Server? Thank you for your help

Sha

Shan,

I have >80 dimensions in my database. The first limit you will probably hit
(though it is rather far ahead) is 256 dimension levels per cube.

HTH
Szymon Slupik

"Shan" <anonymous (AT) discussions (DOT) microsoft.com> wrote

use MS SQL 2000 32-bit version. Is there a upper limit of number of
dimensions or number of members can be created in Analysis Server? Thank you
for your help.

Shan,

I have >80 dimensions in my database. The first limit you will probably hit
(though it is rather far ahead) is 256 dimension levels per cube.

HTH
Szymon Slupik

"Shan" <anonymous (AT) discussions (DOT) microsoft.com> wrote

use MS SQL 2000 32-bit version. Is there a upper limit of number of
dimensions or number of members can be created in Analysis Server? Thank you
for your help.