Thursday, July 24, 2014

Delegation in 2013 - Don't Misundurstand the Project Pro Message

One interesting feature Project Server has introduced in 2010 is the capability to substitute yourself to someone else using the delegation.
By the way, you cannot use it while in SharePoint Permission mode

One of the drawback is that this is only working in PWA interface (except for the Business Intelligence part).
Consequently, Project Professional will not allow you to connect to a server while you have an ongoing delegation session.
So now, let's imagine you're in a delegation session in the name of this famous John.

Then, you try to open your MS Project Pro connected to your server and, Surprise, a misleading message appears.

It's not that wrong message as you do have inadequate permissions but not really explicit!

So, next time a user call you with this kind of message, make sure they are not using the delegation in the meantime before trying to check network or permissions to the server!

Share this article :

Tuesday, July 8, 2014

Manage Calendars using Recurrence Pattern

One of the challenge of planning with MS Project is to be accurate in the dates and vacations.
Though, statutory holidays coming every year needs to be taken into account!

Let's take the example of the 4 of the US holidays found in Wikipedia:
Official Name Date
New Year's Day January 1 (Fixed)
Birthday of Martin Luther King, Jr. Third Monday in January
Inauguration Day First January 20 following a Presidential election
Good Friday The Friday before(western) Easter
Interesting in those holidays is that they happen every year. Some can be set recurring, some not:
January first is always the January first (hopefully for those who are partying all New Year eve).
Martin Luther King, Jr. birthday is the 3rd Monday of January. Strange for an anniversary but still, the public holiday is like that.
For the Inauguration Day, this is not possible to predict when it will happen, recurrence will not help in that case
The Good Friday is arriving before Easter, which is again unpredictable and though, the recurrence will not help either.

MS Project and though Project Server is proposing a nice feature in setting recurrence to exceptions in calendar. 
You will first have to go to the Calendar setting:

After creating an exception, while clicking to the details detail button, you will get the following window:

Now, see how to set the above defined recurring and not recurring holidays.
January first:

Martin Luther King, Jr. birthday:

Inauguration Day:

Good Friday:

Now you can declare enterprise calendars with mostly recurring statutory holidays. Some will still need to be entered one by one.
Obviously, this can be configured for Project Server calendars in going to enterprise calendars in the PWA settings

In the next future, I will share with you some calendars until 2020!

Additional note thanks to Gary Chefetz comment:
While creating recurrence, you will have to identify exceptions such as first of January falling on a Sunday. Then a creation of a specific calendar exception will be necessary. The easy way to identify such case would be to check each calendar exception year after year and verify which day it falls.

Furthermore, try to limit your calendars horizon to your projects horizon to not overload the server and the database with unnecessary information

Hope you will love to avoid defining calendar exceptions every year!
Share this article :