Home > Project Server 2013 > Configure an OLAP Cube in project server 2013

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)
Advertisements
Categories: Project Server 2013
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: