Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Analysis Services (2000)
 Any limitations on Cubes in MS Analysis Server

Author  Topic 

NgKH
Starting Member

15 Posts

Posted - 2004-07-20 : 00:01:02
Do you know if there is any limitations to the Cubes in MS Analysis Server? The following are the limitations I wanted to find out:

1)maximum capacity of Cubes size in MB

2)maximum # of Dimensions

3)maxmium # of measures

Thanks in advance

NgKH

chadmat
The Chadinator

1974 Posts

Posted - 2004-07-20 : 12:33:16
quote:
Originally posted by NgKH

Do you know if there is any limitations to the Cubes in MS Analysis Server? The following are the limitations I wanted to find out:

1)maximum capacity of Cubes size in MB

2)maximum # of Dimensions

3)maxmium # of measures

Thanks in advance

NgKH




1. I don't think there is a limit here.

2.
Dimensions in a Cube - Dimensions in a cube 128 maximum
Dimensions in a DB - 65,535 maximum, regardless of the number of cubes or whether dimensions are shared or private.

3.
Measures in a cube - 1,024 maximum
Measures in a virtual cube - 2,048 maximum


-Chad

http://www.clrsoft.com

Software built for the Common Language Runtime.
Go to Top of Page
   

- Advertisement -