SharePoint (and Project Server) Shenanigans

I am a Project Server and SharePoint consultant but my main focus currently is around Project Server. I have been working with Project Server for nearly five years since 2007 for a Microsoft Gold Certified Partner in the UK, I have also been awared with the Microsoft Community Contributor Award 2011. I am also a certified Prince2 Practitioner. This article has been cross posted from pwmather.wordpress.com (original article)

A quick post to highlight a simple way to remove the HTML tags in the Project Online OData reports. If you are unsure about what I mean, see the image below:

Notice the <p> tag and &#160 tag in the Changes column above, as well as the list tags. An easy way to clean this up is to use Replace function in Power Query:

This can be seen below too:

let
    Source = OData.Feed("<PWAURL>/_api/ProjectData/Projects()?$Filter=ProjectType ne 7"),
    #"Removed Other Columns" = Table.SelectColumns(Source,{"ProjectName", "Changes"}),
    #"Replace HTML <p>" = Table.ReplaceValue(#"Removed Other Columns","<p>","",Replacer.ReplaceText,{"Changes"}),
    #"Replaced HTML </p>" = Table.ReplaceValue(#"Replace HTML <p>","</p>","",Replacer.ReplaceText,{"Changes"}),
    #"Replaced HTML &#160" = Table.ReplaceValue(#"Replaced HTML </p>"," ","",Replacer.ReplaceText,{"Changes"}),
    #"Replaced HTML <ul><li>" = Table.ReplaceValue(#"Replaced HTML &#160","<ul><li>"," ",Replacer.ReplaceText,{"Changes"}),
    #"Replaced HTML </li><li>" = Table.ReplaceValue(#"Replaced HTML <ul><li>","</li><li>",", ",Replacer.ReplaceText,{"Changes"}),
    #"Replaced HTML </li></ul>" = Table.ReplaceValue(#"Replaced HTML </li><li>","</li></ul>"," ",Replacer.ReplaceText,{"Changes"})
in
    #"Replaced HTML </li></ul>"

Then your report will look like this in Excel:

This also works for Power BI too, without the replace function:

Using the replace function:

I have only included a few of the HTML tags / mark-up that you will find but as you can see, it will be easy enough to do the rest.

This is a quick and simple way but you could look to do this in bulk for all columns and HTML tags by creating your own function if you needed to.

I am a Project Server and SharePoint consultant but my main focus currently is around Project Server. I have been working with Project Server for nearly five years since 2007 for a Microsoft Gold Certified Partner in the UK, I have also been awared with the Microsoft Community Contributor Award 2011. I am also a certified Prince2 Practitioner. This article has been cross posted from pwmather.wordpress.com (original article)

Quick post to reference my session for the Project Virtual Conference on 22nd October 2015:

http://bit.ly/1GnVUoe

See some of the great reporting options for Project Online.

For the full schedule see: http://bit.ly/1Vspllo

To register for this great free event (no travel expenses either!): http://bit.ly/1GnVUof

I am a Project Server and SharePoint consultant but my main focus currently is around Project Server. I have been working with Project Server for nearly five years since 2007 for a Microsoft Gold Certified Partner in the UK, I have also been awared with the Microsoft Community Contributor Award 2011. I am also a certified Prince2 Practitioner. This article has been cross posted from pwmather.wordpress.com (original article)

The new Project Online Resource Managements feature might now be available on your Project Online tenant – if it is not yet then it probably will be soon! It hasn’t quite made it to my test tenants yet but when it does I will create a few posts on this new feature. For now see the links below for details:

http://bit.ly/1KBXljN

http://bit.ly/1U0h1VO

I am a Project Server and SharePoint consultant but my main focus currently is around Project Server. I have been working with Project Server for nearly five years since 2007 for a Microsoft Gold Certified Partner in the UK, I have also been awared with the Microsoft Community Contributor Award 2011. I am also a certified Prince2 Practitioner. This article has been cross posted from pwmather.wordpress.com (original article)

A quick post to highlight a new tool that is going to be released soon called Office 365 Planner. This tool is great for organising team work with projects, tasks, assignments, documents in a visual way. For more details and screen shots see the link below:

http://bit.ly/1OubZ3v

I am a Project Server and SharePoint consultant but my main focus currently is around Project Server. I have been working with Project Server for nearly five years since 2007 for a Microsoft Gold Certified Partner in the UK, I have also been awared with the Microsoft Community Contributor Award 2011. I am also a certified Prince2 Practitioner. This article has been cross posted from pwmather.wordpress.com (original article)

Some times organisations want to update the Name description on the PDP to something else. This simple script will do that, the example in the script will work for the Enterprise Project EPT but could easily be updated for other EPTs. The script can be downloaded here:

http://bit.ly/1Posuvj

The script is very similar to the one I created to change the Owner label: http://bit.ly/1e8QwhB

This code will replace “Specify a name for the Enterprise Project” with “Enter a name for the project” but can easily be updated. All it does is replaces the string, so if you had multiple different EPT’s  where you wanted to update the Name description the script would need to be modified to suit as the EPT name is used in the description.

To get the script to work you will need to download the following jQuery library: jquery-2.1.1.min.js – jQuery download Another version of this library may work but this was the one I used / tested with. Upload this library to your PWA site collection then update the script file with the correct location. I uploaded this file to the Shared Documents library as you can see in the code below:

Alternatively you can reference a CDN if preferred.

Once the script is downloaded, upload this to the PWA site collection, in this example it was uploaded to the shared documents library. Select the PDP that has the Name field displayed, then reference the uploaded script using the content editor web part:

Once loaded, “Specify a name for the Enterprise Project” with “Enter a name for the project”:

This is a very simple script but do test this before rolling out to production etc.

The script is provided “As is” with no warranties etc.

I am a Project Server and SharePoint consultant but my main focus currently is around Project Server. I have been working with Project Server for nearly five years since 2007 for a Microsoft Gold Certified Partner in the UK, I have also been awared with the Microsoft Community Contributor Award 2011. I am also a certified Prince2 Practitioner. This article has been cross posted from pwmather.wordpress.com (original article)

Just a quick update to the post below:

http://bit.ly/1K7feXH

The Project Server 2013 September 2015 CU Server Roll up package also known as the Uber packer is now available:

http://bit.ly/1NKE1I7

I am a Project Server and SharePoint consultant but my main focus currently is around Project Server. I have been working with Project Server for nearly five years since 2007 for a Microsoft Gold Certified Partner in the UK, I have also been awared with the Microsoft Community Contributor Award 2011. I am also a certified Prince2 Practitioner. This article has been cross posted from pwmather.wordpress.com (original article)

Project Server 2016 preview is now officially available (it has been in the SharePoint 2016 preview for a few weeks). See the link below for details:

http://bit.ly/1KiHJCD

Download today and take a look.

I am a Project Server and SharePoint consultant but my main focus currently is around Project Server. I have been working with Project Server for nearly five years since 2007 for a Microsoft Gold Certified Partner in the UK, I have also been awared with the Microsoft Community Contributor Award 2011. I am also a certified Prince2 Practitioner. This article has been cross posted from pwmather.wordpress.com (original article)

The Office 2013 September 2015 updates and cumulative updates are now available, please see the links below:

http://bit.ly/1OcxULy

Project Server 2013 September 2015 CU Server Roll up package:
***There is no cumulative / server roll up package this month*** See: http://bit.ly/1K7feXI

Project Server 2013 September 2015 update:
http://bit.ly/1OcxULz

Project 2013 September 2015 update:
http://bit.ly/1K7fg1N

Also worth noting, if you haven’t done so already, install Service Pack 1 http://bit.ly/1uorn2C first if installing the September 2015 CU.

The Office 2010 September 2015 updates and cumulative updates are now available, please see the links below:

http://bit.ly/1OcxULy

Project Server 2010 September 2015 CU Server Roll up package:
http://bit.ly/1K7feXJ

Project Server 2010 September 2015 update:
http://bit.ly/1OcxW6g

Project 2010 September 2015 update:
http://bit.ly/1K7ffdW

SP2 is a pre-requisite for the Office 2010 September 2015 updates.

As always, fully test these updates on a replica test environment before deploying to production.

I am a Project Server and SharePoint consultant but my main focus currently is around Project Server. I have been working with Project Server for nearly five years since 2007 for a Microsoft Gold Certified Partner in the UK, I have also been awared with the Microsoft Community Contributor Award 2011. I am also a certified Prince2 Practitioner. This article has been cross posted from pwmather.wordpress.com (original article)

Following on from my previous post on getting started with the portfolio analysis / strategy functionality where we looked at setting up the drivers and prioritisations we will now look at the analysis part. If you missed the first part, see the link below

http://bit.ly/1N0J4Co

In PWA, click the Portfolio Analyses link from the quick launch menu:

Firstly you might want to set up any project dependencies using the Project Dependencies button on the ribbon:

Dependencies are used to include or exclude projects, there are four options:

A “Dependency” is used if you have a situation where one project is selected (primary project) another group of projects are then required. A “Mutual Inclusion” is used if you have a situation where you have a group of projects that all need to be selected if one is selected. A “Mutual Exclusion” is used in the opposite situation to the Mutual Inclusion, if one of the projects is selected then the other projects in the group must not be selected. A “Finish to Start” is used if one project is selected (primary project) then the other projects in the group can’t start until the primary project is finished.

For this post, I have not set up any project dependencies as my data set is very small so we will now create an analysis.

Click the Portfolio Analyses link from the quick launch menu then click the New button on the ribbon and complete the details on the page, this includes a name and description, choosing the prioritisation type, selecting the projects to include and the cost custom field to use for the cost constrain analysis:

As you can see, there is also the option to analyse resource constraints, we will check this check box and more options will appear:

The options here include setting the start and end dates for the planning period to review, the planning granularity (months or quarters), the role custom field – in this example this was updated the “Primary Skill” custom field that was created. There are other settings to filter the resources either by department or RBS, the assignment booking type to use (committed only or committed and proposed assignments) and the project start and finish dates. In this example these were left as default apart from the role custom field.

Next click the Prioritize Projects button in the bottom right corner, this will show the project driver impacts as previously set on the Strategic Impact PDP:

The values can be changed here if needed by clicking in the cell. Click the Review Priorities button in the bottom right corner and the project priorities will be displayed:

Next click the Analyze Cost button in the bottom right corner:

The “Budgeted Cost” field will include the total from all of the projects in the analysis – this is the baseline scenario. If cost wasn’t a constraint we could just leave it there as all projects are selected. What we will do now is reduce the cost limit to $400,000 and recalculate:

Now a project has been moved out of the selection and the strategic value has reduced from 100% to 78%.There are two different charts to view, the default is the Efficient Frontier but there is also a Strategic Alignment chart:

You can also switch from a grid view (default) to a Scatter chart view:

Back on the grid view we can see it moved out the “Migrate Project Server to Project Online” project:

This might be a project we need to run so at that point we can force it in:

Now click the recalculate button on the ribbon to see the impact, it moved out the “New Document Management Solution” project but this also reduced the overall strategic impact to 76%:

This might be the scenario we need so as this point click the Save As button on the ribbon:

You can create multiple scenarios and compare these using the Compare button on the ribbon, this will give you a report like below:

Click close to return to the analysis. You can switch between the scenarios using the Scenario drop down menu:

Now the cost analysis has been done the resource analysis can be reviewed if required, click the Analyze Resources button on the ribbon:

As you can see, analysing the resources has also de-selected another project, the “Migrate Project Server to Project Online” project. This is due to lack of resource availability. At this point you can view the Deficit and Surplus reports:

In the screen shot above you can see that I have negative availability values for the IT Admin role in September and October. Detailed screen shot below:

You can also use the Requirements Details report – this is useful to see where there is a lack of resource availability for the projects, you can see in the resource availability grid the IT Admin role has 0 for September and October and project requirements grid highlights the resource deficit for the de-selected project in red:

You can also highlight the deficit in the resource availability grid using the check box in the top corner:

So now we have two options, we can either change the start date for one of the projects or hire additional resources. Switch back to the Gantt Chart view and in the Metrics sections, add 1 in the hired resources field:

Then press the recalculate button on the ribbon and both projects will be selected:

I will save this scenario as 1 hired resource:

In this example we know we needed an IT Admin for two months but in a large real world portfolio it is likely you would need many resources, the Hired Resource report will detail the type of resources you need, what projects they need to work on and how long you need them for:

Hiring resources is a great option if you are able to do so and when the project deadlines can’t slip.

The other option without hiring resources is to change the start of a project, switch back the the Gantt Chart and change the scenario to the baseline:

We are now back to the original resource analysis where only one project is selected, in the New Start date column for the de-selected project, change the date to July 2015 and recalculate:

Now the project is selected as the IT Admin role has availability then. This scenario can then be saved if required.

The next steps would be to commit the selected portfolio using the Commit button:

This action updates certain fields for the project and can also be used in a project workflow event for moving a project between stages – workflow will be coved in the next mini series of getting started.

Clicking on the quick launch link for the Portfolio Analyses will show all of the scenarios you just saved with links to each:

That is it for the getting started series for the Portfolio Analysis / Strategy functionality – a very quick intro but hopefully enough to get you started if you haven’t used this feature before.

I am a Project Server and SharePoint consultant but my main focus currently is around Project Server. I have been working with Project Server for nearly five years since 2007 for a Microsoft Gold Certified Partner in the UK, I have also been awared with the Microsoft Community Contributor Award 2011. I am also a certified Prince2 Practitioner. This article has been cross posted from pwmather.wordpress.com (original article)

Following on from a very popular series of blog posts on “Getting Started with Project Online” I have decided to extend that with another Getting Started series of posts for two areas I didn’t cover in the original getting started series found here: http://bit.ly/1IFInbc

The first mini getting started series will cover the Portfolio Strategy / analysis functionality then we will do the same for Project Workflow.

The Portfolio Strategy feature enables you to align projects with defined business drivers and objectives, the tool can then prioritise the projects based on how they fit with the business driver prioritisation. Further analysis can be done based on cost / resource constraints to work out the projects to run for the best strategic value. A detailed white paper for Project Server 2010 can be found here: Portfolio strategy with Project Server 2010 (white paper). The feature is the same in Project Online. This post will give a quick getting started intro to this feature.

For the purpose of this post I have a vanilla PWA instance with very little data. I have created a new Project Level custom field called “Budgeted Cost” and a new Resource level look up table field called “Primary Skill” – these will be used later. I have also created three very simple projects with values for “Budgeted Cost” and assigned resources to the tasks – these resources also have Primary Skills tagged against them. The projects contain some over allocations to show the resource analysis part. The projects I have are:

Here are the resources:

Now I can get get on with configuring the Portfolio Analysis part. Firstly I will create 5 business drivers. First I need to enable the Strategy links on the quick launch menu, click Edit Links on the left hand quick launch menu:

Check the check box for Strategy and the three links below the Strategy heading:

Click Save & Close from the ribbon menu. Now you should see these links appear on the quick launch menu:

Now we can see the Strategy links we can set up the drivers. To do this click on the Driver Library link and you will see the following:

Click the New button on the ribbon menu and complete the form for the first driver:

Complete each of the fields as required – only the Name is a mandatory field. Once you have created your drivers the Driver Library screen will look like this:

As you can see I have created the following drivers:

• Increase Market Share
• Increase Sales
• Decrease Internal Costs
• Improve Staff Morale

Now the drivers need to be prioritised, click the Drive Prioritization link on the quick launch menu and you will see the page below:

Click the New button on the ribbon and complete the form:

Click the button on the bottom right corner of the page to “Prioritize Drivers” and you will see the page to rate the drivers against each other:

In the example above I clicked the arrow in the “Select a Rating” box and choose how “Decrease Internal Costs” rates against the other drivers like below:

Once the first driver is completed it will look like this:

Click the Next Driver button in the bottom right corner to set the ratings for the next driver. Repeat this process until you get to the final driver then click the Review Priorities button in the bottom right corner. You will then see the driver priority as below:

What is key here is that the rating has been consistent, expand the Consistency Ratio option:

This should be at least 80%, the higher the better. You can create multiple driver prioritisations for different scenarios etc.

The next part is the analysis but before we look at that we will jump back to the Project Center and edit each project to set the impact of each project against the drivers, this is done on the Strategic Impact PDP as seen below for one of the example projects:

This was done for the 3 example projects I have created.

Now that is set up the next part is to create an analysis but that will be covered in Part 2 that will follow.