Discussion Locked

Huge Cube - Analysis Service

0 helpful
0 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

0 replies

No replies were posted before this discussion closed.

This discussion is closed to new replies.