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.