#ProjectOnline time phased data rollup for #OData reporting #PPM #PMOT #BI #Excel #PowerBI

November 17, 2017 at 11:44 am | Posted in Administration, Configuration, Functionality, Information, Reporting | Comments Off on #ProjectOnline time phased data rollup for #OData reporting #PPM #PMOT #BI #Excel #PowerBI
Tags: , , , ,

Recently it was announced that it would be possible to rollup some of the data in the time phased feeds for Project Online, the support documentation can be found here: https://support.office.com/en-us/article/Configure-rollup-of-timephased-reporting-data-in-Project-Online-da8487fe-899e-4510-a264-e2ebc948928c

Currently today in Project Online, the time phased data is stored in the Reporting schema at the day level. For some organisations, this is too granular and they end up having to aggregate the data for reports to weekly / monthly etc. For those customers, having the data at the day level isn’t convenient as storage / performance improvements can be gained from having the data stored at source pre-aggregated. With this change, that will now be possible.

I believe this feature will start rolling out in the next week or two but let’s have a quick look at the options. From the PWA Settings menu you will see a new option under Enterprise Data for Reporting as seen below:

image

This shows the following page:

image

As this new feature has been rolled out to an existing PWA site, this defaults to Daily but new PWA sites created once this feature is rolled out to the tenant will have this setting set to Never.

Let’s look at the impact on the data using my simple project plan that has a task with a duration of 5 days:

image

Using the TaskTimephasedDataSet you can see the data below for Task 2:

image

As expected, there are 5 days displaying work. I will now change the setting to Weekly:

image

For this change to take effect I will need to publish all of my projects but for the purpose of this blog post I will just publish my test project. Refreshing my Excel data, you can see I have two rows as the task spans two weeks:

image

The hours are aggregated on the first day of the week as defined by the PWA site regional settings:

image

Now I will increase the task duration to 50 days to span a few months and set the reporting to monthly then publish my test project. Updated project:

image

Updated to Monthly:

image

Updated Excel report:

image

As you can see the hours are now aggregated on the first day of the month. You can also base this on the fiscal periods defined in PWA.

The feeds that are impacted by this change are:

  • AssignmentBaselineTimephasedDataSet
  • AssignmentTimephasedDataSet
  • TaskBaselineTimephasedDataSet
  • TaskTimephasedDataSet

Once available in your tenant, set the time phased data reporting setting as defined by your reporting requirements and publish all of the projects. I would recommend you did this on a non-production PWA instance first as you might need to update you reports, apps etc. that consume date from those four feeds. Also remember to set this up for new PWA instances created once this feature is live as they will be set to Never.

Keep an eye out for this feature reaching your tenant soon.

Advertisements

#ProjectServer and #SharePoint 2013 / 2016 November 2017 Cumulative Update #PS2013 #SP2013 #PS2016 #SP2016 #MSProject

November 16, 2017 at 9:20 am | Posted in Administration, CU, Fixes, Functionality, Information, Installation | Comments Off on #ProjectServer and #SharePoint 2013 / 2016 November 2017 Cumulative Update #PS2013 #SP2013 #PS2016 #SP2016 #MSProject
Tags: , , , , , , ,

The Office 2016 November 2017 updates and cumulative updates are now available, please see the links below:

https://support.microsoft.com/en-us/kb/4051890

Project 2016 November 2017 update:
https://support.microsoft.com/en-us/kb/4011227

SharePoint Server 2016 / Project Server 2016 November 2017 update: 
https://support.microsoft.com/en-us/kb/4011243 & https://support.microsoft.com/en-us/kb/4011244

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

https://support.microsoft.com/en-us/kb/4051890

Project Server 2013 November 2017 CU Server Roll up package:
https://support.microsoft.com/en-us/kb/4011249

Project Server 2013 November 2017 update:
https://support.microsoft.com/en-us/kb/4011257

Project 2013 November 2017 update:
https://support.microsoft.com/en-us/kb/4011235

Also worth noting, if you haven’t done so already, install Service Pack 1 http://support2.microsoft.com/kb/2880556 first if installing the November 2017 CU for 2013.

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

Blog at WordPress.com.
Entries and comments feeds.