Configure an OLAP Cube in project server 2013

Project Server as a product introduces collection of reports for helping projects managers, portfolio managers, and top managers in the organization in tracking the projects plan , measuring the performance of employees , and tracking projects Issues and Risks, …

To build reports in project server, you need to configure OLAP Cube

1. Install SQL Server Native Client on SQL Sever

   (http://go.microsoft.com/fwlink/?LinkId=123718&clcid=0x409)

2. Then install SQLSERVER2008_ASAMO10 on Project Server 2013 Application Server

   (http://go.microsoft.com/fwlink/p/?LinkId=130655)

3. Restart Project Server Service from Central Administration –> System Setting –> Services on server
4. Add FarmAdmin to administrators group on SQL Server Analysis Service.

   (In Management Studio: Connect to Analysis Services->right click->properties->Security ->Add->FarmAdmin )

5. Give Analysis Service User SPDataAccess Permission on Project Server Service DBs (PWA)