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
--Disable the trace flags
and you should see something like this
More details can be found here: