Archive

Archive for the ‘Cross Post’ Category

Project Server Start Date Reporting Quirk

July 11, 2013 1 comment

I came across a little possible pitfall while generating some reporting for a client, which I thought I should share with the community.

 

In Microsoft Project, the Start Date in Project Information defaults to the Start Date of the first task in the plan.

image

Obviously this can be changed in the Project Information so that the Start Date of the Project does not necessarily reflect the Start of the first task in the plan, or the Project Summary task.

image

So which date does appears in the reporting database? Well, here are the results:

From the MSP_EpmProject_UserView view in the reporting database

image

As you can see, the date from the MSP_EpmProject_UserView displays whatever is set in the Project Information. This might cause some unexpected information in reports, so we need to expand our query to include the date from the Project Summary task:

image

So, when writing the specifications for your reports, make sure you’re clear which date the client wants – it’s not unheard of having a plan created a few months in advance of the work being realistically scheduled which might cause this confusion!

Obviously the clear process-driven workaround is to have your Project Managers ensure that the Start Date in Project Information is updated when scheduling the project!

Advertisements

Transitioning from #SP2013 to #PS2013 for Enterprise Project Management #SPSUK #MSProject #SharePoint

November 30, 2012 3 comments

Just a quick note to say that I will be presenting at SharePoint Saturday UK on December 8th 2012 on:

Project Site to Project Management

Transitioning from SharePoint to Project Server for Enterprise Project Management

Video Title

Session Objectives:

After attending this session you will understand the different tools for Project Management offered with SharePoint and Project Server, including the advantages / disadvantages of each method.

In addition you will also takeaway:

  • A high level understanding of how SharePoint / Project Server work together
  • The benefits of enterprise project management
  • Project management maturity expectations as solutions become more complex

Agenda:

  • What’s Project Server / Project Online
  • Understanding Project Maturity
  • Supporting Tools
  • Transition – Simple to Complex
  • Demo
  • Decisions – Where to start?
  • Conclusion

Where, When, How?

  • Conference: SharePoint Saturday UK 2012
  • Location: Nottingham
  • Date: Saturday, 8 December 2012
  • Conference Times: 09:00 to 17:00 (GMT)
  • Presentation Time: 13:30 to 14:30
  • Presenter: Giles Hamson
  • Full Address:

East Midlands Conference Centre
University Park
NG7 2RJ Nottingham
United Kingdom

If you see me during the day, say hello and I hope you all enjoy the conference.

%d bloggers like this: