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.