#ProjectOnline data flows diagram #Office365 #PPM #MSProject

August 23, 2018 at 9:51 pm | Posted in Administration, Configuration, Functionality, Information | Comments Off on #ProjectOnline data flows diagram #Office365 #PPM #MSProject
Tags: , , ,

I have put together a very simple diagram to describe some core data flows in Project Online / Project Server for actions like opening projects, save a project on a PDP etc. This high level diagram can be seen below:

ProjectOnlineDataFlows

Click the image to see a larger version.

There are probably some scenarios where this image isn’t 100% accurate but it gives you a good starting point for most core scenarios / data interactions with Project Online and Project Desktop.

I hope that you find it useful – happy to extend it / update it with more Project Online data entities if people find it useful!

Advertisements

New #ProjectOnline #Project Home #Office365 #PPM #UI #UX #MSProject #FabricUI

August 20, 2018 at 7:29 pm | Posted in Administration, App, Functionality, Information | 3 Comments
Tags: , , ,

Recently you may or may not have seen that Project Online has a new Project Home page to improve access and navigation to the projects that you need access to. Those of you that navigate directly to your Project Online PWA URL probably won’t have noticed the new feature, those of you that use the Project app from the app Office 365 app launcher / waffle might have seen this if your Office 365 tenant has been updated.

Access Project from the Office 365 App Launcher:

image

Or from the office.com site (click Explore all your apps):

image

This feature is currently rolling out, at the time of writing clicking the Project app on my tenants just directed me to the default /sites/PWA site as it always has done since Project Online was launched. Whilst this feature rolls out fully you can still try and access the new Project Home by navigating directly to https://project.microsoft.com if this has reached your tenant yet. If the feature hasn’t rolled out to your tenant yet, you might see a message stating that you don’t have access to this page.

On one of my demo tenants I can access this:

image

When you first access the Project Home app, you will see the placeholders for the projects if you have no data there, you have a favourites sections and a Recent section. Here is the page after accessing a few projects on my demo system:

image

I have 4 projects in my recent list as seen above. You can hover over the project row in the Recent list to add a project as a favorite using the star icon or click the ellipsis to see a menu and use the the Add to favorite menu option:

image

This then pushes the projects to the favorites section:

image

You can then click the ellipsis on the card to remove a project as a favorite:

image

Clicking the project card or project name row in the recent list will navigate you to the project detail page (PDP) – the last PDP you accessed just like it does from the Project Center page as this uses the projectdrilldown.aspx page which will load the last PDP you accessed for that project.

The recent project list will contain projects from multiple Project Web App (PWA) instances on the same Office 365 tenant to give you that central Project Home page for all projects you accessed. By default you will see 8 projects on the recent list ordered by the last accessed time, once you reach more than 8 project, you have the Show more control:

image 

This will then display the next 8 projects, keep pressing Show more until all are displayed, you then see a Show less control:

image

You have the same feature on the favorites section too:

image

Also on this page you can use the Create New > Project feature:

image

This will launch the Create a new project wizard page on the default PWA instance on the tenant – the default instance is /sites/PWA:

image

You also have the ability to navigate to the the default PWA instance (_sites/PWA) homepage using the “Go to Project Web App –>” link:

image

Or the Project link on the top nav bar:

image

On the settings cog you have the license information:

image

This loads a license page that displays the licenses for the 3rd party software packages / libraries used in Project Home.

Great to see a new look and feel for Project making use of the Office Fabric UI React components.

Reporting on #ProjectOnline Resource Cost Rate Tables #Office365 #PPM #PowerBI #Excel #PowerQuery #MSProject

August 10, 2018 at 4:18 pm | Posted in Administration, Configuration, Customisation, Functionality, Information, Reporting | 1 Comment
Tags: , , , , , , ,

The resource cost rate table details are not available in the Project Online / Project Server OData Reporting API (_api/ProjectData) but they are accessible using OData but from the CSOM REST API (_api/ProjectServer). In this blog post, I will walkthrough getting this data into an example Power BI report. It wont look pretty, that’s not the idea of this post!

To get this data you need to use the _api/ProjectServer API as seen below in the example for cost rate table A:

{PWAURL}/_api/ProjectServer/EnterpriseResources(‘{RESGUID}’)/CostRateTables(‘A’)/CostRates

Which gives the detail:

SNAGHTML5adc642

To get all of the resources different cost rate A details, you would need to dynamically pass in the RESGUID. In the steps below we look at doing this in Power Query so this would work for either Power BI or Excel but for the purpose of the blog post, I’m using Power BI.

In Power BI, create a new OData connection using the Get Data > OData option. Use the following URL:

{PWAURL}/_api/ProjectServer/EnterpriseResources(‘{RESGUID}’)/CostRateTables(‘A’)/CostRates

Update with the correct PWA URL and a valid resource GUID from that PWA instance. Edit the data so it loads the Power Query Editor:

image

I renamed this to fn_getResCostRateA as this will become a function. Open the advanced editor:

SNAGHTML581e6c0

The code needs to be updated to:

SNAGHTML5817fb9

Click done and you will see the following:

image

No need to do anything with the parameter or buttons. Now we need to add another data source in for the resource metadata. Add a new new OData data source in from the Power Query Editor window and use the following URL:

{PWAURL}/_api/ProjectServer/EnterpriseResources?$Select=Id,Name&$Filter=ResourceType ne 3

Update with the correct PWA URL. This will get the list of resource GUIDs to pass into the function and also the resource name to be used in the report. I renamed the connection to Resource Details – Cost Rate Table A:

image

Once you have edited the query as required a new custom column needs to be added to invoke the function created earlier. Click the Add Column tab then click Custom Column. Give the column a name such as GetCostRateADetails then enter the following: fn_getResCostRateA([Id]) as seen below:

image

When clicking OK, this might take a while depending on how many resources you have as this will invoke the function for each project and call the REST API, passing in the Id for that row and bring back the cost rate A table records. Once completed you will see the tables as below in the new custom column:

image

Now the column needs to be expanded, click the double arrow in the custom column heading and expand the cost rate fields:

image

Click OK and the data will refresh / load then display the data for the cost rate fields:

image

Notice for those resources with multiple cost rate table entries there are multiple rows per resource. These are just resources from the Microsoft Project Online demo content with updated cost rate entries.

That’s it, now load into Power BI and create the report – a basic table example below:

image

For other cost rate tables, repeat the process but replace the A for the other cost rate tables such as:

{PWAURL}/_api/ProjectServer/EnterpriseResources(‘{RESGUID}’)/CostRateTables(‘B’)/CostRates

This dynamic function process is the same process I’ve used and detailed before in previous blog posts for Power Query such as this one: https://pwmather.wordpress.com/2018/01/03/projectonline-powerbi-report-include-html-formatting-ppm-pmot-powerquery-odata-rest-part-2/

Blog at WordPress.com.
Entries and comments feeds.