Cube process stuck - finished building aggregations and indexes for the partition

Question

Hi friends

My cube processing stuck up at "Finished building aggregations and indexes for the partition". How can I troubleshoot this.

Appreciate your help. 

---

Royal Thomas

Answer 1

Hi Thomas ,

Do you have enough space on the hard disk ? around 10 times than the final cube space .

Have you tried to process the dimension first and then the partitions one by one ?

---

Regards, David .

Answer 2

Hi Royal,

In addition to the previous reply by David, limit number of rows in fact tables using clauses such as SELECT TOP N or WHERE in DSV. Try process cube again. Will the trouble appear again ?

Best regards.

Answer 3

Royal,

Your question is discussed here and here also. May be it will help you out.

Best regards.