Missing workload data in the Resource Centre? Portfolio Optimisation Resource Analysis not working? The solution might be easier than you think!

Posted By Posted by: Tania Barra-Shaw Harmelink on January 8, 2020

If you are having issues reporting on your project resources availability, either through the Resource Centre or Portfolio Optimisation, don’t panic.  The first instinct will be to wonder what Project Online has done to your data; and the answer is nothing.  All Resource utilisation data is available, the trick is to simply make it visible

Read More


Blog Posted In 

OData On-Premise Vs Project Online

Posted By Posted by: Cheston Hsu on November 20, 2019

Problem: I have a custom field named “Schedule Status” and for some reason despite a value appearing on a PDP (Project Details Page) there is no value appearing in my OData feed. Below is the PDP that shows the current RAG Statuses of my project: And below is the feed I get from OData: Notice

Read More


Blog Posted In Blog Posted In: Blog, Project Online
Blog Posted In 

Project Online & deactivated Active Directory resources

Posted By Posted by: Dan Stopher on October 16, 2019

Background An organisation decides to synchronise with an Active Directory (AD) group to populate either their enterprise Resource Pool or a User group such as Team Members in Microsoft Project Online. The IT department deactivates a user in the AD Group and a synchronisation with Project Online occurs after the deactivation. Outcome As expected, the

Read More


Blog Posted In 

Clearing Microsoft Project cache to resolve issues on opening, saving or publishing projects

Posted By Posted by: Eremo Zanye on July 23, 2019

Cache is a component of Microsoft Project that stores your project data locally on your computer, the concept exists to boost the speed in which data is retrieved. The functionality works in such a way that when you save a project for the first time, all the data information about that project is saved in

Read More


Blog Posted In Comments Off on Clearing Microsoft Project cache to resolve issues on opening, saving or publishing projects

How to close a Project (not task) to timesheets

Posted By Posted by: Dan Stopher on July 2, 2019

In the PPM community it is fairly well understood that we can use the “Lock Tasks to Timesheets” function to stop a timesheet user being able to log time against those tasks in a timesheet. However, I recently had the request where the client was not logging effort against tasks but rather projects and wanted

Read More


Blog Posted In Blog Posted In: Blog, How to, Project Online
Blog Posted In 

Updating a Project Site Template

Posted By Posted by: Cheston Hsu on June 26, 2019

The Project Site Template dictates the look, feel as well as the contents of a project site when created. Hence, it is extremely important that any changes that are made on the template are changes that you would like to see on your FUTURE project site. The below is a guide on how to update

Read More


Blog Posted In Blog Posted In: Blog, How to, Project Online
Blog Posted In 

How to get a unique project number between different Enterprise Project Types

Posted By Posted by: Ahmed Taee on June 14, 2019

I was faced with a requirement to produce unique project numbers in sequence despite of the project EPT type. Project numbers such as: PPMxxxxxx (x are consecutive numbers starting from 000001). Requirements Project Server 2016 or Project Online. SharePoint Designer 2013. So this was the approach I took in producing the unique project numbers:  Create

Read More


Blog Posted In Blog Posted In: Blog, How to, Project Online
Blog Posted In 

What does the Remove Task feature do on timesheets?

Posted By Posted by: Cheston Hsu on June 5, 2019

Users when seeing this button may use it to remove a task from their timesheet without understanding what it truly does. The intent of this button is for user, to reject a task that has been assigned to them. Once the rejection has been approved by the project manager, the user is no longer assigned

Read More


Blog Posted In Blog Posted In: Blog, Project Online
Blog Posted In 

Using PowerBI REST API to overcome frustrating oData URL filter limitation

Posted By Posted by: Peter Williams on May 28, 2019

The Problem I had a need to create report that consumed the following data sources: Project Online timesheet data SharePoint Online list info On-Premise SharePoint list info Zendesk ticket data I have a reasonable amount of experience using PowerBI to query and consolidate this information. My desire was to have a report that used essentially

Read More


Blog Posted In Blog Posted In: Blog, How to, Project Online, Reporting
Blog Posted In