I have noticed that the two cubes we use are not reprocessing as they should.
The tasks that reprocesses the cubes is a scheduled DTS package. The task executes without a problem Mon - Thurs but on Fridays and over the weekend the task seems to run without completing. The fact tables for the two cubes have approx 15 million and 70 million records respectively and I am of the view that it is not related to the amount of data within the tables.
The only way to reprocess the cubes is either to restart the server or stop/start the analysis service.
I haven't had this problem before and am curious as how to cure the problem and prevent it occurring. Hope someone has seen this behaviour and has a solution.