Creating an OData Data Feed Report to get resource utilization information RRS feed

  • Question

  • Hi,

    I want to create a resource utilization report to show the percentage of assignment work divided by resource capacity in MS Project Server 2013. And I want to group the resource list by the resource department.

    I tried Portfolio Analyzer OLAP cube. But when I grouped the resource list by the department, the subtotals (divisional resource usage) get wrong. 

    Then I tried to create it using OData Data Feed. I used AssignmentTimePhasedData, Resource and ResourceTimephasedData entities. I created relationships between Resource - ResourceTimePhasedData and Resource - AssignmentTimePhasedData. But still, it doesn't display properly. I cannot create another relationship between AssignmentTimePhasedData and ResourceTimePhasedData because of the other two active relationships.

    How can I solve this? Has anyone got this information any other way?

    Thank you very much.

    • Edited by Mudi Vand Monday, November 9, 2015 8:35 AM Forgot to mention the project server version.
    Monday, November 9, 2015 7:22 AM


All replies