Some #ProjectServer default fields not in the Reporting Database #PS2010 #MSProject #SP2010

December 19, 2011 at 10:10 am | Posted in Administration, Configuration, Functionality, Reporting, T-SQL, Workarounds | Comments Off on Some #ProjectServer default fields not in the Reporting Database #PS2010 #MSProject #SP2010
Tags: , , ,

Not all default fields are available in the Project Server Reporting database, for example the Contact and Resume fields. To be able to easily include these fields in reports using direct T-SQL you will need to get the values for these fields in the Project Server Reporting database. The easiest was to achieve this is to create a new custom field that uses a formula and reference the default field. The new custom field will then be available in the reporting database. Below is walkthrough guide using the Contact field to show you what I mean.

Task 1 in the project below has PaulM as the Contact as seen below:

image

To get this value in the Reporting I will create a new Task Level custom field called TaskContact that uses a formula of [Contact] as shown below:

image

Now I need to open and publish the project/s so that the TaskContact custom field pulls in the values from the default Contact field and synchronises these values to the Reporting database when published. You can see below that the Contact PaulM is now available in the MSP_EPMTask_UserView for Task1.

image

Advertisements

Create a free website or blog at WordPress.com.
Entries and comments feeds.

%d bloggers like this: