project server projects list integration with sharepoint 2010

Question

We would like to integrate project server 2010 with sp 2010 for dashboards, reports, projects lists data.

What is the best way to do this? Is there any custom development required or we can use sharepoint 2010 features like performancepoint, excell services.

---

MCTS Sharepoint 2010, MCAD dotnet, MCPDEA, SharePoint Lead

Answer 1

Hi ,

Microsoft Project Server 2010 integrates the Microsoft SharePoint Server 2010 Business Intelligence Center Web application, which
provides a central point for hosting the reports, dashboards, and report connections that can be auto-created or manually authored to provide access to reporting data in Project Server for your users.

In order to configure reporting ,you need to perform the actions below :

1. Add a login for the report authors group in SQL Server
2. Install SQL Server 2008 Analysis Management Objects
3. Start Excel Services
4. Configure Excel Services settings
5. Start the Secure Store Service
6. Configure Secure Store Service settings
7. Populate the Report Authors and Report Viewers Active Directory groups
8. Configure Business Intelligence Center access

For more information ,please refer to this site:

Configure reporting for Project Server 2010: http://technet.microsoft.com/library/ee662106(office.14).aspx
Business Intelligence in Project Server 2010 : http://technet.microsoft.com/en-us/projectserver/ff513702

Thanks

---

Entan Ming

TechNet Community Support