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 | Leave a comment
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

Leave a Comment »

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

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

%d bloggers like this: