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
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”.
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
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
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 –
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
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
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
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
