Olap Cube is taking several hours to build on SQL 2005
Following the performance trend I was thinking to blog some of the best practices for the Project Server.
Some old issues related to the Olap Cube performance are related to the SQL Server flag. After enabling this flags I've seen improvements from several hours to several minutes.
--Enable the trace flags DBCC TRACEON(-1,4121,4101) --Disable the trace flags TRACEOFF(-1,4121,4101)
and you should see something like this
More details can be found here: