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.
| Author |
Topic |
|
cheesel
Starting Member
1 Post |
 Posted - 2004-04-03 : 11:27:59
|
| Hi,recently a cube that i have developed has a problem when i want to archive the database. The Analysis manager pops a message saying that the partition data is too big for archiving. The size of the partition data is over 2GB. Any help as to how can i solve this problem?In addition, i am also doing incremental process and currently my cube takes about 10 hrs to complete processing. My knowledge on cube is limited, thus am wondering;1)Is it normal for a cube to take 10 hrs to complete process?2)Is there anyway, i can cut down or minimise the processing time?3)Does analysis service cube has a limit or problem dealing with huge cubes?thank you. |
|
|
|
|
|
Huge cube