Tuesday, 27 June 2017

Updated feature: Project Online Rollup of Task and Assignment Timephased Data

Here is a communication update from Microsoft O365 support team, affecting Project Online.



Published On : June 21, 2017

Expires On : October 31, 2017

Action required by September 18, 2017

We’re adding the ability for a PWA admin to set how to rollup task and assignment timephased data. We’ll support weekly, monthly, fiscal period, or the previously supported by day grouping for timephased data. You could also choose to have no timephased data. You’ll have the option to choose which one you’d like to use.

How does this affect me?

If you choose to use this new option, you may benefit from simplified report building, reduced storage requirements, and improved report generation performance. However, existing reports that make use of the following entities could be impacted by this change:

- AssignmentBaselineTimephasedDataSet

- AssignmentTimephasedDataSet

- TaskBaselineTimephasedDataSet

- TaskTimephasedDataSet

We'll be gradually rolling this out in September, and the rollout will be completed by the end of October.

What do I need to do to prepare for this change?

Please review any reports that make use of the task and assignment by day information from the Project Online OData service once this feature is available to your organization. If your reports are rolling up timephased task and assignment data by one of the following new units: weekly, monthly, or by fiscal period, we recommend updating your reports to take advantage of the rollups for better performance. If you have an app that queries all the properties without specifying the property names, it may be impacted by this change. We recommend you set the apps query for specific properties. Read More below.


Configure rollup of timephased reporting data in Project Online

Applies To: Project Online

IMPORTANT:  This article describes the Timephased Data configuration settings that will soon be available. The purpose of this article is to help you plan for this upcoming feature, as it could offer you better performance when using reports that make use of the task and assignment by day information from the Project Online OData service.

Project admins can configure Project Online to roll up timephased reporting data to different levels of granularity. They can choose to roll up their data daily, weekly, monthly, or by fiscal period and retrieve the data through the timephased OData endpoints:

  • AssignmentBaselineTimephasedDataSet

  • AssignmentTimephasedDataSet

  • TaskBaselineTimephasedDataSet

  • TaskTimephasedDataSet


A key benefit this provides is that it can help to improve report generation performance, especially in organization that have a lot of Project Online reporting data. While retrieving task and assignment timephased reporting data by day was the only option available previously, many organizations do not need this level of granularity. Being able to retrieve their data on a broader scope (such as weekly or month) can greatly improve report generation performance by reducing the amount of records that need to be downloaded. For example, instead of needing to retrieve 300,000 records when set to daily, setting to monthly could reduce this to a much lower number, such as 10,000 records.

Additionally, other benefits can include simplified report building, and reduced storage requirements.

How do I configure this setting?

  1. In Project Online home page, select Server Settings.

  2. On the Server Settings page, in the Enterprise Data section, select Reporting.

  3. On the Reporting page, in the Timephased Data section, select the option that you need:

    • Never

    • Daily

    • Weekly

    • Monthly

    • By fiscal period

Timephased Data settings

Tip: If you don't use any of the timephased Odata feeds, we highly recommend setting the Timephased Data option to "Never" which provides the added benefit of much faster Reporting Publish queue jobs.

Planning considerations I need to make

  • Republish existing projects - After changing the Timephased data setting, it will only take affect in an existing project if it is republished.

    NOTE: If you have many projects to republish, you can programmatically publish your Project Online projects. You should plan to do this at a time that will be least likely to impact your organization.

  • New instances - In new Project Online instances, note that the Timephased data default setting is Never. Make sure to select the appropriate Timephased data setting after creating your new instance to prevent the need to republish all your projects at a later time. Do also consider the tradeoffs associated with a more granular setting e.g. Daily vs Monthly with regards to the time it takes to Publish as well as pull down the timephased OData feed.

Tuesday, 13 June 2017

Updated feature: Calculated field in SharePoint lists and libraries

Please be aware of the upcoming change.

Action required by June 14, 2017

Calculated fields in SharePoint lists and libraries running in the classic UI mode can be used to create conditional or derived values to display to users as if there were native metadata on the item or document. Some users have added HTML markup or script elements to calculated fields. This is an undocumented use of the feature, and Microsoft will begin blocking execution of custom markup in calculated fields in SharePoint Online on June 13, 2017. And, they are providing this option to SharePoint Server 2016 and SharePoint Server 2013 in the June 2017 and subsequent Public Updates, adding the option for the same optional capability on-premises.

How does this affect me?

Your administrators will have been notified if you have one or more SharePoint Online lists and libraries in your organization that are using unsupported calculated fields. Beginning June 13, 2017, markup contained in calculated fields will be ignored. In many cases, calculated fields containing markup will be displayed as blank values in list and library views.

What do I need to do to prepare for this change?

You can request a one-time extension, until September 10, 2017, during which time unsupported markup will be rendered by calculated fields.  Please click Additional information to learn more.

Monday, 5 December 2016

Feature Pack 1 for SharePoint Server 2016 now available


When Microsoft launched SharePoint Server 2016, they shared their vision that it would be a foundational release, born in the cloud and built for continuous innovation. On 8th November Microsoft announced their next step on this journey with the availability of Feature Pack 1.

Through the November 2016 Public Update for SharePoint Server 2016, Microsoft delivered several new features based on customer feedback, extending support for hybrid scenarios and developer needs, including:

  • Administrative actions logging for common SharePoint administrative actions.
  • MinRole enhancements to support small and medium-sized farms.
  • A OneDrive for Business modern experience.
  • Custom tiles in the SharePoint app launcher.
  • SharePoint hybrid auditing unified across site collections on-premises and in Office 365.
  • Hybrid taxonomy unified across on-premises and Office 365.
  • OneDrive API for SharePoint on-premises.

Tuesday, 24 May 2016

Collaboration platforms vs. best-of-breed. What to Consider When Planning Your Collaboration Infrastructure

Why Your Organization Should Buy a Collaboration Platform Instead of Best of-Breed Solutions?

Collaboration platforms vs. best-of-breed solutions


“Should we use a group of products from a single vendor or purchase different features from multiple specialized vendors?” This question, otherwise known as “suites versus best-of-breed,” is one of the oldest and most important that IT decision makers have to answer. But is the question still valid?

A recent study from Constellation Research, Inc. argues for the suite approach. Read the report to see why.


Saturday, 9 April 2016

What's new for admins in SharePoint Server 2016

Here is a demonstration of what's new in SharePoint Server 2016. If you've been testing the Release Candidate or Preview releases of SharePoint Server 2016, you'll be aware of the foundational updates we've made. Bill Baer shows what's been recently added - durable links, new admin experiences and updated hybrid capabilities when connecting to Office 365 services.

Wednesday, 20 January 2016

SharePoint Server 2016 and Project Server 2016 Release Candidate available

Building on the announcement of SharePoint Server 2016 Beta 2 in November, here is SharePoint Server 2016 Release Candidate (RC). SharePoint Server 2016 RC is mostly feature complete and represents an important milestone for customers and partners looking to deploy and evaluate SharePoint Server 2016 before general availability in Spring 2016.

Read more >> https://blogs.office.com/2016/01/20/sharepoint-server-2016-and-project-server-2016-release-candidate-available/

Sunday, 17 January 2016

Beware!! Jan 2016 Security Patch MS16-004 (KB3124585) Breaks SharePoint 2013

January Security Patch Can Break SharePoint 2013.

Please be mindful that just applying the security update for SharePoint servers, without the full SharePoint/Project Server CU can cause issues. I would high recommend that user don't enable Automatic Updates on SharePoint Server, but instead, download and install them manually. Be in control of what is being applied to the servers. Not only does a 'bad' patch break SharePoint, it cannot be uninstalled.