Wednesday, 10 June 2015

Support for Microsoft Office 2013 RTM has ended

NOTICE from the Microsoft Office Sustained Engineering Team

Support for Microsoft Office 2013 RTM has ended.  Starting with the April 2015 release, all Office 2013 updates will only apply if Office 2013 SP1 is installed.  See KB2817430 for more information about acquiring Office 2013 SP1.

The June 2015 Public Update releases for Office are now live. June 2015 Office Update Release

Friday, 5 June 2015

OLAP Excel Report - How to Show Work in Days rather than Hours?

Applies: Project Server 2007, 2010, 2013 OLAP Reporting

This post will guide you to create a custom column in OLAP cube report;

1. Once you have configured OLAP and have created pivot table. Click on MDX Calculate Measures (Analyze >> Calculations >> OLAP Tools >> MDX Calculate Measures)


Figure 1 Showing MDX Calculated Measures

2. In New Calculated Measure window.

· Enter Name of measure i.e. name of calculated field.

· Select the field to be used from “Fields and Items” tab.

· Click on “Insert”. Selected field will be displayed in White area under “MDX” label apply appropriate formulation.

· Select appropriate group from “Measure Group”

· To verify MDX click on “Test MDX”.

· Click on Ok.


Figure 2 Creating MDX Calculated Measures

3. Above newly added Measure one can find in Pivot Table field listing under a group selected during above step.


Figure3: Showing newly added Measure in PivotTable fields

4. Click on check box next to field to add field to Pivot Table.

Wednesday, 3 June 2015

Microsoft Shoring Up Tasks with Wunderlist To-Do App

The Berlin-based company behind the Wunderlist to-do app has been purchased by Microsoft Relevant Products/Services. Redmond reportedly agreed to buy 6Wunderkinder GmbH for between $100 million and $200 million.

The purchase will indeed bring Microsoft something it lacks, namely mobile task management capability.

"Microsoft Project is a very heavyweight solution, geared toward large teams and complex project planning, and is not targeted to individual or small team use," said Stowe,managing director of research and analyst firm workfutures. "Although Project is integrated with Office as Project Online, it doesn't really solve the need for lighter weight task management, and is definitely not a 'mobile first, people first' product, which Wunderlist is, with very popular iOS and Android apps." 


I personally would like to see this integrated with SharePoint and Project Server Task Management.

Tuesday, 19 May 2015

Enterprise Calendars Use Case

Applies: Project Server 2007+

Here are a few considerations when working with Enterprise Calendars. Enterprise Calendars can be assigned to Projects, Resources and Tasks.


1) Project Calendar

An Enterprise Calendar assigned to a Project impacts all the Tasks within the project schedule. E.g. tasking will NOT take place on weekends etc.

Note: ensure that the project scheduling OPTIONS for task working times match that of the project calendar.

PMO will need to keep this Enterprise Calendar updated for exceptions such as weekends, public holiday etc.


2) Resource Calendar

Resource Calendars are based on a specific Enterprise Calendar, normally the BASE calendar that the project is based on, so that it inherits the exceptions such as weekends, public holiday etc.


Resource Managers/PMO can add further exceptions to the resource calendar for specific resource availability/exceptions e.g. holidays etc.

Note: if a Resource calendar is based on a different BASE calendar to that of the project, then the resource calendar scheduling will take precedence. E.g.  an international Project is based on UK holidays and Resource in Middle East is based on UAE calendar (with Friday/Sat off and Sun working). Any task that has the UAE resource assigned will show as working on Sunday. The scheduling for the assigned task  is governed by the working times of the resource on that task, i.e. based on that resource’s calendar (BASE Calendar + exceptions).


3) Task Calendar

If you want to override the default scheduling behaviour of resource calendar, then you will need to set the scheduling exception against the task and assign a different/specific calendar. See figure below to override the Resource Calendar scheduling.


Note: if you want to update multiple[le task calendars en-mass, inside of a project,  you can insert the following two columns/built in fields. And then Copy/fill-down to all the tasks in the project. Alternatively, you can write a macro and add to Enterprise Global, to do this for programmatically.


Hope this helps.

Wednesday, 6 May 2015

SharePoint Server 2016 update

Today, Microsoft confirmed that SharePoint Server 2016 will become generally available in Q2 2016, with a public beta planned for Q4 2015, and commitment to delivering on-premises releases of SharePoint for the foreseeable future. There will be support for combination of on-premises, cloud and hybrid deployments for many years to come.  Learn More>>

Thursday, 12 March 2015

How to Delete OLD Status Reports to avoid Receiving Alerts and Notifications

Affects: Project Server 2007+

To delete/remove old Status Reports, do the following;

1) Navigate to the the Status Reports Page

2) Select the specific Status Report Request

3) Click Delete Request on the Toolbar


If you delete your REQUEST the associated RESPONSES for that Request will also be deleted by the system automatically. If, however, another PM has sent you a REQUEST that you need to respond to, then please ask them to remove their REQUEST.

Hope this helps.

Wednesday, 4 March 2015

SharePoint & Project Server – Feb 2015 Public Updates Really??

The last update for SharePoint & Project Server 2013 was announced as Public Update available along with Windows Updates! Here is why you should disable this immediately?

SharePoint and Project Server updates need to be applied planned with DUE CARE;

  1. Applied ONLY if you have an issue that is resolved by the update.
  2. Applied after due testing on your dev/test environment with COPY of live data. Testing to include key/normal business processes.

A few key things to remember with SharePoint and Project Server updates/patching;

  1. There is no roll-back for SharePoint and Project Server, as there is for Windows update!! if you have some data related issues or key services running in the background, then patching will not be applied correctly. Remember, key services need to be STOPPED prior to patching on each Web Server. Surely you would want to take precautions, take full backups, ensure you have a bullet proof roll-back/back-out plan in the event of failure.
  2. Patching is a two two step process. If you simply update bits and database schema is not upgraded by running the SharePoint Configuration Wizard on each web server, then your databases will be left in COMPATIBILITY mode, leading to potential issues and unknown data corruption downstream.
  3. Project Pro is recommended to be at the same patch level as the server, so you would have to update/patch ALL the users’ client application at the same time.
  4. Some Patches have dependencies on other Service Packs!

SharePoint/Project Server System Administrators should apply the patches manually as a carefully planned exercise. Take control of your system today!!

I will follow up this post with steps/guidelines to manually patch your SharePoint and Project Server 2013 environment.