Configure Rollup of Timephased Reporting Data in Project Online

Many organizations need reports that retrieve Tasks and Assignments timephased data. The problem is performance issues, especially in organizations that have a lot of Project Online reporting data.

Microsoft acknowledged that not all organizations would need the timephased data to be reported by day. So they introduced an option to roll up the data on a broader time frame (such as weekly or monthly) this can significantly improve report performance by reducing the number of records that you need to download.

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.

Note: This feature is currently only available with project online.

Another benefit of rolling up timephased data is that time to publish projects is a lot faster since data won’t need to be broken down by the day when publishing. Also in some cases, it can improve the performance of interacting with Project Detail Pages. Organizations that have complex workflows could also benefit from this feature where users will see performance improvements when publishing the projects to complete or move to the next PDP.

How to change 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

For more information about Project Online Configurations reporting, please contact EPMA.

For more information on how we can help you and your project management team, send us an email

If you are looking to kick start your project management journey, sign up for our Microsoft Training Classes. We hope you find this blog post helpful.  For more tips and tricks on Project Management, follow us on LinkedIn and Instagram