There appears to be an error currently on our TechNet documentation at http://technet.microsoft.com/en-us/library/ee662106.aspx indicating that the version of the Analysis Management Objects required when building an OLAP cube from Project Server 2013 depends on the version of SQL Server you have running Analysis Services. In fact it does not – and like previous versions of Project Server we actually require a specific version that our code talks to – regardless of which version it will actually be building the cube on. For Project Server 2013 we require the ‘10.xx’ release so anything from RTM SQL Server 2008 Analysis Management Objects – version 10.0.1600.60 through to the SP2 of the SQL Server 2008 R2 10.50.4000.0 will work. The only one that does not work in my testing is the SQL Server 2012 version.
*** Update 11/13 – I should also point out that the requirement for the SQL native client is fulfilled by the SharePoint pre-requisite installer – so no need to add anything – but if you remove it then you will likely get an error like “Error: The ‘SQLNCLI10’ provider is not registered on the local machine” If this happens then just re-install SQL Native client 10.x such as the one from http://www.microsoft.com/en-us/download/details.aspx?id=30440 – look for sqlncli_amd64.msi. End Update ***
If you have the 2012 version, or if you haven’t loaded any Analysis Management Objects then you will see the following error when trying to build a cube.
[11/12/2012 10:17 AM] Failed to build the OLAP cubes. Error: The attempt to build the OLAP database on server BriSmithSQL 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.
The SQL Server 2008 R2 SP2 version is the most recent and can be found in the feature pack at http://www.microsoft.com/en-us/download/details.aspx?id=30440 and you are looking for SQLSERVER2008_ASAMO10_amd64.msi (which is the x64 version) (***Update *** corrected the name – thanks Adrian!). Direct download link is here. I haven’t tried building a cube against a SQL Server 2008 instance – that may need to use the earlier SQL Server 2008 feature pack – most recent is SP2 if you find the R2 version above doesn’t work.
For those still having a hard time finding where we have hidden the cube building option (I admit it – it took me a while…) can find it either by going to Central Administration, Manage Service Applications, Project Server Service Application (or whatever you have called yours) and then use the drop down for the specific PWA site you are interested in and click Manage which will take you to the following page – and OLAP Database Management is the link you need:
Or Central Administration, General Application Settings, and click Manage under the PWA Settings header.
If you go this root you may need to change the PWA site in the upper right hand corner.
And if you are using the preview of Project Online (or you are reading this after the full release) and can’t find the link to OLAP cubes it is because that feature isn’t available in the online version.