General discussion
March 31, 2004 at 09:57 PM
cheesel

Huge Cube – Analysis Service

by cheesel . Updated 22 years, 6 months ago

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.
I have checked the size of the partition data and found that it is over 2GB.

How can i solve this problem?

In addition, i am also doing incremental process and currently my cube takes 10 hrs to complete processing.

My problem and worries here are:
1) As time goes by, my cube process time will increase. Is there anyway, i can cut down or minimise the processing time?

2) Does analysis service cube has a limit or problem dealing with huge cubes?

thank you.

This discussion is locked

All Comments