One issue or query that has been raised a few times is that when reporting on manually scheduled tasks and auto scheduled tasks the Start / Finish date fields do not show the same data that they do in Project or PWA for the manually scheduled tasks. For example, take a look at the example... Continue Reading →
#Microsoft #ProjectOnline Reporting Pack v2 #MSProject #SharePointOnline #Office365 #PPM #Excel #BI #Data
Following on from my recently released Project Online Reporting Pack, I have since added a new report to the pack – a milestone variance chart. This report is detailed in this post. For screenshots of the other reports and deployment steps, see: https://pwmather.wordpress.com/2014/09/05/microsoft-projectonline-reporting-pack-msproject-sharepointonline-office365-ppm-excel-bi-data/ The v2 Project Online Reporting pack with the 6 reports can be... Continue Reading →
#Microsoft #ProjectOnline Reporting Pack #MSProject #SharePointOnline #Office365 #PPM #Excel #BI #Data
I have recently created a reporting pack / report starter pack for Project Online. These can be downloaded from the Microsoft Gallery link below: http://gallery.technet.microsoft.com/Online-Reporting-Pack-431f075e Currently there are only 5 reports in the zip file but I will be regularly updating the existing reports and create additional reports. The reports will only use the intrinsic... Continue Reading →
#ProjectServer #ProjectOnline highlight report example #PS2013 #SP2013 #Excel #BI #Office
A common requirement for clients is to have a report that highlights key information about each project. This usually includes any key project level fields, up and coming tasks / milestones and any active issues or risks. For previous versions of Project Server, in my opinion, the best reporting technology for this was SQL Server... Continue Reading →
#ProjectServer #Excel report with SQL Temporary Tables #PS2010 #PS2013 #SQL
I came across an issue a while back and meant to blog about it but forgot until a colleague of mine today mentioned the same issue. This jogged my memory of the fix so I thought it was a good time to write the post. The issue isn’t Project Server related but the reports and... Continue Reading →
#ProjectServer #PS2013 #Excel Pivot Table limitation
Just a quick post to highlight a limitation / issue with Excel Pivot Tables that I hadn’t seen before, details below. This particular Pivot Table uses a Data Model that contains two OData feeds from Project Server 2013, one for Project details and one for Task details. The connections can been seen below: The relationship... Continue Reading →
#ProjectServer 2010 #Excel Services Reports fail to Refresh #Office2013 #SP2010
A quick post to highlight an issue you may face if you have upgraded to Office / Excel 2013. I recently created some Excel reports for Project Server 2010 using Excel 2013. These reports failed to refresh in Excel Services. After a quick check on the connection string in Excel, the provider is MSOLAP.5 rather... Continue Reading →
#Excel Services REST API in #SSRS report #ProjectServer 2010 #PS2010 #MSProject #SP2010 #SharePoint
Following on from my previous post that demonstrated embedding Excel Services objects in Word using the Excel Services REST API, this post demonstrates using the Excel Services REST API in SSRS reports. Once you have gone to the time and effort creating the charts in Excel services you don’t want to have to go to... Continue Reading →