If you are experiencing slow OLAP Cube Builds after, for example, a migration to new Hardware and OS – consider to check and change the following settings.
These have also been mentioned in a Post by Brian Smith.
In order to enable the SQL Server query optimizer hotfix you have to enable the trace flag 4199. (I am talking about SQL Server 2008 R2 SP3, Version: 10.50.6000.34)
To do so:
When trying to save a Resource in PWA, you get the message:
The resource could not be saved due to the following reasons: A resource availability contour cannot go outside the range of the resource’s earliest and latest availability dates.
When you open the Resource in Project Professional 2013 and have look at the “Resource Information”, the “Resource Availablity” under the “General”-Tab looks quite strange, like this:
