Share via

Project Online Reporting Pack / Solution Starter

  • Article

 

Introduction

If you want to get started with Project Online, there is a Project Online Reporting Pack, which can be downloaded from the Microsoft Gallery at: http://gallery.technet.microsoft.com/Online-Reporting-Pack-431f075e

Currently there are only 5 reports in the zip file but we will be regularly updating the existing reports and create additional reports. The reports will only use the intrinsic Project Online fields so will works for all deployments, the only requirement will be to repoint / update the data connections with the correct Project Online PWA URL – this is covered on this post.

The reports included so far can be seen below, the data isn’t great as it in test data but you get the idea!

 

Issue Report

This report will show all of the issues in the PWA site collection, you can filter by the Enterprise Project Type:

https://pwmather.files.wordpress.com/2014/09/image_thumb.png?w=527&h=216

 

Risk Report

This report will show all of the risks in the PWA site collection, you can filter by the Enterprise Project Type:

https://pwmather.files.wordpress.com/2014/09/image_thumb1.png?w=527&h=214

 

Portfolio Dashboard

This report will display general information for the projects in the portfolio, this includes how the projects are split between EPTs, project costs, project work, issues and risk count then a detail table below. The data can be filtered by the Enterprise Project Type:

https://pwmather.files.wordpress.com/2014/09/image_thumb2.png?w=527&h=203

https://pwmather.files.wordpress.com/2014/09/image_thumb3.png?w=527&h=199

 

Project Highlight Report

This Power View report displays general project related information including cost, work, %complete. It also includes milestones and marked tasks from the project plan as well as active issues and risks.

https://pwmather.files.wordpress.com/2014/09/image_thumb4.png?w=527&h=370

 

Project Dashboard

This dashboard report displays general project related information including cost, work, %complete and  issue / risk information. It also includes milestones and marked tasks from the project plan.

https://pwmather.files.wordpress.com/2014/09/image_thumb5.png?w=527&h=258

https://pwmather.files.wordpress.com/2014/09/image_thumb6.png?w=527&h=260

These are the first 5 reports, others will follow in the future. When updates / change or additional reports are added we will update the zip file on the Microsoft Gallery but also blog about them too.

To get started with these reports once they are downloaded, see the steps below for one example report, in the example below we use the IssueDashboard file. The steps will need to be repeated for all reports / connections. Before you carry out the steps below, please ensure that your target PWA tenant has some data to populate all of the tables and charts in each Excel file, otherwise Excel will remove the tables or charts etc. If it is a new tenant, make sure you have some projects in there with work and cost including baselines, ensure there are milestones / marked tasks and ensure there are risks and issues for the associated projects.

  1. Open the Excel file in Excel 2013 and enable any connections if Excel prompts. When Excel prompts to login in, cancel this.
  2. Click Data > Connections and select Enterprise Project Type Slicer:
  3. https://pwmather.files.wordpress.com/2014/09/image_thumb7.png?w=406&h=281
  4. Click Properties then the Definition tab.
  5. https://pwmather.files.wordpress.com/2014/09/image_thumb8.png?w=337&h=451
  6. The connection will be “https://cpssalesonlinedemo2.sharepoint.com/sites/pwa”, this part of the connection needs to be updated for your PWA URL. There are two places in the connection string it needs to be updated, the Data Source property and the Base URL property. You can see both in the screen shot above where it has cpssalesonlinedemo2 and below it was updated this to 'Paulmather' in both locations:
  7. https://pwmather.files.wordpress.com/2014/09/image_thumb9.png?w=358&h=479
  8. Click OK
  9. At this point Excel might prompt you to login in to your Office 365 PWA tenant – the your credentials if you have access to PWA and the ODATA Reporting Service, alternatively use an account that has admin access to PWA.
  10. https://pwmather.files.wordpress.com/2014/09/clip_image002_thumb.jpg?w=308&h=307
  11. Repeat the same steps for the Issues Data connection.
  12. Refresh the data if required and you should see the dashboard update with your data.
  13. An additional step might be required if you want the Excel work book to automatically refresh on open and that is to enable the option “Refresh data when opening the file” on the Usage tab for each connection:
  14. https://pwmather.files.wordpress.com/2014/09/image_thumb10.png?w=342&h=434
  15. Now the file can be saved to your Project Online PWA instance so that users can view this file via the web using Excel Services.
  16. Repeat these steps for all Excel files in the Report Pack download. Please note some reports have more than 2 data connections, you will need to update them all.

 

Source reference