Understanding Reporting in Microsoft PPM

Posted By Posted by: Laith Adel on July 8, 2015

PPM Reporting Overview A key driver for many organisations adopting a PPM solution, is the desire to gain better insight and visibility of a project portfolio through reports. The Microsoft PPM Solution is based on Project Server which, in combination with the underlying technologies of SQL and SharePoint, provides a powerful, feature rich ‘Business Intelligence

Read More


Blog Posted In Blog Posted In: Blog, Reporting
Blog Posted In 

Error and Solution: The INSERT statement conflicted with the FOREIGN KEY constraint

Posted By Posted by: Peter Williams on April 13, 2015

We recently received an issue where our client was unable to see a project in their Project Status Report. They had tried publishing the project and received a “Failed But Not Blocking Correlation”. The error below was found in the project server queue: ReportingProjectChangeMessageFailed (24006) – The INSERT statement conflicted with the FOREIGN KEY constraint “FK_MSP_EpmAssignmentByDay_ProjectUID_AssignmentUID”.

Read More


Blog Posted In 

How to Create a Query for Lookup Tables in Row Number Order

Posted By Posted by: EPM Partners on March 4, 2015

For your reporting needs, you may want to display values from a Lookup Table exactly in the order they are saved in PWA. Within PWA, this setting is controlled using “Display order for lookup table” option on Edit Lookup Table Page.     However, this sort order is not available in Reporting Database. Following query

Read More


Blog Posted In Blog Posted In: How to, Reporting
Blog Posted In 

Project Online – SSIS OData Replication – Lessons Learned

Posted By Posted by: EPM Partners on September 24, 2014

I recently had the chance to work on an SSIS Package in Windows Azure environment which periodically retrieved the Project online data via OData connector and stored over an Azure SQL Database for SSRS based reporting. Here are some of my takeaways from this exercise. Learning Resources The article to get you started is: MSDN

Read More


Blog Posted In Blog Posted In: How to, Reporting
Blog Posted In 

It’s a Wrap….Highlights from the Worldwide Partner Conference (WPC)

Posted By Posted by: Dan Stopher on August 11, 2014

The annual Microsoft Worldwide Partner Conference (WPC) was in early July.  Senior consultant, Dan Stopher, attended on behalf of EPM Partners and joined more than 16,000 people in Washington DC to gain valuable insights into the direction in which Microsoft is heading. Dan reports the conference was an amazing experience. Senior Microsoft Management representatives –

Read More


Blog Posted In Blog Posted In: Reporting
Blog Posted In 

2014 Microsoft Project Conference Booth Highlights

Posted By Posted by: Laith Adel on May 2, 2014

FluentPro Booth We’ve had the pleasure of being in contact with the guys at FluentPro for many years, and our pick of nifty products this year would have to be the FluentPro “Formulas”. If you are familiar with deploying Project Server and the configuration of the Enterprise Custom Field, you will at some point realise

Read More


Blog Posted In Blog Posted In: Reporting
Blog Posted In 

EPM Partners’ 2014 Webinar Series

Posted By Posted by: Laith Adel on February 16, 2014

EPM Partners’ Centre of Excellence is a series of webinars about knowledge, best practices and challenges around Microsoft Project Server-based management solutions. The Centre of Excellence is about real life situations and challenges. Rather than demonstrating product features and functions, it is a presentation from experts and leaders in the field, and where appropriate, will reference real-life

Read More


Blog Posted In Blog Posted In: Reporting
Blog Posted In 

FREE WHITE PAPER: Online and On-Premises Solutions for Project Server 2013.

Posted By Posted by: Laith Adel on February 5, 2014

EPM Partners are currently attending the Project Conference 2014 in Anaheim California and have just received a great whitepaper: Online and On-Premises Solutions for Project Server 2013. An analytical comparison of a cloud solution and an on-premises solution. We thought you would enjoy this article: Project_Server_2013_Online_and_On-Premises_Solutions.pdf


Blog Posted In Blog Posted In: Reporting
Blog Posted In 

Project Online – What it Does and Doesn’t Do

Posted By Posted by: EPM Partners on November 19, 2013

Though Microsoft Project online is less than a year old, and at the time of writing this, not yet launched in Australia, it is based on a proven Microsoft Project Server technology which has come a long way over the last decade and has kept pace with demands of maturing PPM practice worldwide. Being nascent

Read More


Blog Posted In Blog Posted In: Reporting
Blog Posted In