Configuring OLAP on Project Server 2013

·         Central Admin, Application management select manage service applications.  

        Click on Project service application

               Point to Proj Web App instance (PWA) and click on Manage

·         Click on OLAP Database Management

·         On the OLAP Database Management page, click New and Configure the OLAP Database build settings page

·         If you get the following error

·         Download  SSAS Management objects SQLSERVER2008_ASAMO10_amd64.msi  from

http://www.microsoft.com/en-us/download/details.aspx?id=30440

and install it on all the servers where Project Server 2013 is installed.

·         If you get following error

·         Failed to build the OLAP cubes. Error: Failed to create the Olap database: ProjectServerPWA. Error: Cannot set StorageEngineMode property of database 'ProjectServerPWA' to 'Traditional' because Analysis Services is in Tabular mode.

·         Change the C:\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\Config\msmdsrv.ini file

·         You cant directly edit it, copy it over to desktop . modify it and overwrite the original file

·         Restart SSAS service

·