Have you ever looked at the Project Web App home page and felt it was simply too plain for Jane? I understand the need for design simplicity but sometimes the PWA home page simply feels like underutilized real estate. The Need Your manager wants you to add system announcements, support contacts and a list of […]

Please use the following links to download the Service Pack 1 bits. Also, ensure you patch SharePoint and Project Server together. Project 32-bit     http://www.microsoft.com/en-us/download/details.aspx?id=42013 Project 64-bit     http://www.microsoft.com/en-us/download/details.aspx?id=42020 SharePoint          http://www.microsoft.com/en-us/download/details.aspx?id=42008 Project Server   http://www.microsoft.com/en-us/download/details.aspx?id=42011

Microsoft has released the 2013 version of the Project Portfolio Management (PPM) guide for Project Server 2013 and Project Online. You can download it here. http://www.microsoft.com/en-us/download/details.aspx?id=41549  

Scenario You have a report where the need is to show multiple values for a given custom field. For example, you have a multi-value Project custom field for Impacted Business Organizations. You want to see your values as a comma delimited list so that this can be used in an Excel pivot table or SSRS […]

These high level entity relationship diagrams were first published in the deck for my Project Conference Hands On Lab deck. I’ve had a number of requests for this information so here it is. These diagrams are based on the 2010 RDB but the 2013 RDB should not be materially different. For 2007 users, many of […]

At some point, you will be asked for information by Fiscal Year. The Fiscal calendar was set up in Project Server so it should be accessible for reporting, right? A fair number of companies have fiscal calendars which don’t exactly line up with the standard calendar which can cause some challenges. You could hard code […]

A successful configuration of Project Server is one that supports the conversations within the organization. Users have to go beyond use of the system and have concerns over the validity of the data entered. The Project instance captures the requisite information for the conversations and enables participant to synthesize additional outputs and insights. Therefore, an […]

Security configuration is a confusing topic for many new and old to Project Server. This series provides a in-depth look at the security model and provides decision points and suggested best practices where applicable. We’ll also work through some common scenarios so that you can see how to best utilize the Project Server security model. […]

If you’ve ever attempted to include content from a Project multi-line text custom field or Issues multi-line fields in an Excel report, you will get a result that looks like this: <div><p>Vendor is having issues with deliveries to the East Coast.</p></div> At the 2012 Project Conference, I presented a SQL based solution that converts the […]

If you are planning to write reports over your Project Server data, you will need to know about the Reporting Database or RDB for short.   A Little History In Project Server 2003, all of the data was typically in one database.  Since this database was optimized to support Project Server transactions, reporting on that data […]