Creating a New PWA Instance
1. Access the Sharepoint 2010 Admin Console and select Manage Service Applications
2. Click on Project Server Service Application
3. Click on Create Project Web Access Site
4. Input the properties of the new project Web App site by selection the Web Application to use and the name of the Project Server databases to use, and press OK to provision the new site.
Reposting from http://blogs.msdn.com/project/archive/2010/04/07/how-do-you-report.aspx
Project wants to know how you report. As we plan for future product improvements, we want to learn more about how you report on your project’s status today.
· What tools do you use?
· How often do you report on your project’s status?
· What data do you care about?
· How do you share your reports?
· What do you find difficult with your current process?
Please send any information you’d like to share to email@example.com Screenshots of the reports you use are very useful too – feel free to blur out any confidential data. For example, we just care to see that your report contains late tasks, we don’t need to see the actual tasks that are late.
To learn more about Project 2010 reporting improvements, check out this post.
We're excited to announce that we recently published a new whitepaper by Chris Vandersluis for the "From the Trenches" column in the Project Server TechCenter. The whitepaper is titled The Executive Connection and discusses the importance of executive involvement to having a successful EPM deployment. This is the latest in a series of whitepapers by Chris, all dealing with deploying the EPM solution in the real-world based on his many years of experience. Chris is an excellent writer, so I urge you to read this article and previous ones that he has written for the From the Trenches column. You can access them by clicking here.
Here is some additional information about the author:
Chris Vandersluis is the president and founder of Montreal, Canada-based HMS Software, a Microsoft Gold Certified Partner. He has an Economics degree from McGill University and over 25 years experience in the automation of project control systems. He is a long-standing member of the Project Management Institute (PMI) and helped found the Montreal, Toronto, and Quebec chapters of the Microsoft Project User Group (MPUG). Publications for which Chris has written include Fortune, Heavy Construction News, The American Management Association's Handbook on Project Management, Computing Canada magazine, and PMI's PMNetwork, and he is a regular columnist for Project Times. He teaches Advanced Project Management at Montreal's McGill University and often speaks at project management association functions across North America and around the world. HMS Software is the publisher of the TimeControl project-oriented timesheet system and has been a Microsoft Project Solution Partner since 1995.
Originally posted by Treb Gatte over on the Project Administration Blog. I’m reposting it here to make sure everyone sees it:
The Project Server 2010 Business Intelligence feature utilizes the support of Excel Services, Secure Store Service, PerformancePoint Services and SQL Server. A thorough understanding of how these features fit together is necessary to get the most from the feature. This post will provide that overview and provide troubleshooting questions for common issues.
Our Business Intelligence features leverage Excel Services as the base functionality since most people use Excel to visualize data and it’s a tool that many people already know how to use.
There are four core components to this solution.
Excel client. The Excel Client is used to author and publish new reports. This solution will work with Excel 2007 SP2 or later.
Office Data Connections. Office Data Connections(ODC) are used to store the connection information, the SQL Query and the Secure Store Target Application ID. External ODCs are used to allow you to manage data connection and query information externally to the reports that consume the data. These two components together are the deliverables from the report author.
When you provision a new Project Web Application site or when you create a new OLAP database, ODCs and attached templates will be automatically generated in the Business Intelligence Center.
Excel Services. Excel Services provides rendering and interactivity support on the web. This service enables the user to share reports easily with others. It also enables a user to filter the data in a report dynamically to meet a particular need.
Secure Store. Secure Store is a SharePoint service used to store credentials in a Target Application Profile. These profiles help avoid double hop authentication situations and provide control around who has access to what data for a given Target Application Profile. In SharePoint Server 2007, this service was known as Single Sign-On service or SSO.
The diagram above illustrates the interactions between the four components. The arrows denote what information is passed between the components and in what direction.
Lastly, PerformancePoint is called out above as it is used to create the Business Intelligence Center as it is their service that provides this infrastructure. It isn’t used for the core reporting features. However, you can easily develop PerformancePoint reports over Project Server data.
The setup steps for the Business Intelligence features can be found here. http://technet.microsoft.com/en-us/library/ee662106(office.14).aspx
Please note, if you are using Active Directory(AD), you can set up a AD Group for Report Authors such that you only have to create one SQL Login for the group. The membership of the group is then maintained outside of SQL Server.
Also, you must set up a SQL Login with db_datareader rights for the credentials used in the Secure Store Target Application ID. If you have created the AD group for the authors above and it matches the security needed to service reports, you can simply add the Target Application ID credentials to the Report Author’s AD group instead of creating a new SQL Login.
This can be due to a number of reasons. Here is a list of items to verify. The steps to do each of these items are listed in the setup link above.