Project Sever 2010 - OLAP Cube build failing

Within your PWA application -> Server settings -> Database Administration -> OLAP Database Management. Attempting to build the OLAP cubes in Project server 2010

 

An error occurs with the following description:

Failed to build the OLAP cubes. Error: The attempt to build the OLAP database on server pma-poc-sql01 failed, the SQL Server Analysis Services Analysis Management Objects (AMO) client software may not be installed on this server, please install/update the client on this server and retry. The underlying exception was: Could not load file or assembly 'Microsoft.AnalysisServices, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

After ages trying to get analysis services to work on a project server 2010 with SQL 2008 R2 implementation...

Basically, on all Web Front Ends and Application servers;

• install the SQL 2008 native client
• install the SQL server analysis management objects

You can get these from here:
http://www.microsoft.com/en-us/download/details.aspx?id=8824

Then, head over to central admin -> manage services on server and restart the project application service on all servers in farm (except SQL)

It is also likely you will have to add the farm service account into the SQLServerMSASUser$ local group on the SQL server and add this account also to the security settings in the analysis instance in SQL management studio....

Now, try again to rebuild the cube in PWA. This should then report a build success: