That's the problem, as most of the time the cubes process successfully, especially when ran manually.

It would be great if SSAS has a debug mode that captures the exact reason...

I use this one (cant remember where I found it though):

CREATE TABLE myTable99 (TABLE_NAME sysname, COLUMN_NAME sysname, Occurs int)

GO

SET NOCOUNT ON

DECLARE @SQL varchar(8000), @TABLE_NAME sysname, @COLUMN_NAME sysname, @Sargable varchar(80), @Count...

Is it better to run your backups daily and your tuning (index's,etc) weekly, or should tuning be done before every backup?