none
Looking to get a report/extract by resource of the cost table entries RRS feed

  • Question

  • We are on Project server 2010 and need to do an audit of the cost table entries for our active resources. Specifically, I'm looking for the latest 5 entries (effective date and rate) in cost table A and/or B for each resource. 

    Any thoughts or assistance would be appreciated.

    Dan

    Tuesday, January 26, 2016 3:31 PM

Answers

  • Hello,

    You could read this data using the PSI. here is a link to the Resource class details:

    https://msdn.microsoft.com/en-us/library/websvcresource.resource_di_pj14mref(v=office.14).aspx

    Extract the data and transform it as required then output to a CSV file maybe.

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS | MVP | Downloads

    Tuesday, January 26, 2016 7:10 PM
    Moderator
  • Hi,

    We had similar requirement. Resource cost table entries are readable only through PSI or Project Pro. SSRS report can be used to consume rates table data directly but it will display general data. Following Data source and Dataset can be used to fetch rates data. It worked for me.

    DataSource : Type : XML , Connection String : http://<PWA instance url>/pwa/_vti_bin/psi/Resource.asmx

    DataSet Query : DataSoure : <above datasource>

    <Query>
       <Method Namespace="http://schemas.microsoft.com/office/project/server/webservices/Resource/" Name="ReadResources">
         <Parameters>
    <Parameter Name="xmlFilter" type="String" ><DefaultValue></DefaultValue></Parameter>
    <Parameter Name="autoCheckOut" type="Boolean"><DefaultValue>false</DefaultValue></Parameter>
         </Parameters>
       </Method>
    <SoapAction>http://schemas.microsoft.com/office/project/server/webservices/Resource/ReadResources</SoapAction>
     <ElementPath IgnoreNamespaces="true">ReadResourcesResponse/ReadResourcesResult/diffgram/ResourceDataSet/ResourceRates{RES_UID,RES_RATE_TABLE,RES_STD_RATE,RES_OVT_RATE,RES_COST_PER_USE,RES_RATE_EFFECTIVE_DATE}</ElementPath> 
    </Query>

    As I needed another values (like resource name), I created my own web service. I used PSI to fetch rates data and used joins for other fields.

    Hope this helps.

    Thanks,

    Vedika Sawant.

    Friday, January 29, 2016 8:32 AM

All replies

  • Hello,

    You could read this data using the PSI. here is a link to the Resource class details:

    https://msdn.microsoft.com/en-us/library/websvcresource.resource_di_pj14mref(v=office.14).aspx

    Extract the data and transform it as required then output to a CSV file maybe.

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS | MVP | Downloads

    Tuesday, January 26, 2016 7:10 PM
    Moderator
  • Hi,

    We had similar requirement. Resource cost table entries are readable only through PSI or Project Pro. SSRS report can be used to consume rates table data directly but it will display general data. Following Data source and Dataset can be used to fetch rates data. It worked for me.

    DataSource : Type : XML , Connection String : http://<PWA instance url>/pwa/_vti_bin/psi/Resource.asmx

    DataSet Query : DataSoure : <above datasource>

    <Query>
       <Method Namespace="http://schemas.microsoft.com/office/project/server/webservices/Resource/" Name="ReadResources">
         <Parameters>
    <Parameter Name="xmlFilter" type="String" ><DefaultValue></DefaultValue></Parameter>
    <Parameter Name="autoCheckOut" type="Boolean"><DefaultValue>false</DefaultValue></Parameter>
         </Parameters>
       </Method>
    <SoapAction>http://schemas.microsoft.com/office/project/server/webservices/Resource/ReadResources</SoapAction>
     <ElementPath IgnoreNamespaces="true">ReadResourcesResponse/ReadResourcesResult/diffgram/ResourceDataSet/ResourceRates{RES_UID,RES_RATE_TABLE,RES_STD_RATE,RES_OVT_RATE,RES_COST_PER_USE,RES_RATE_EFFECTIVE_DATE}</ElementPath> 
    </Query>

    As I needed another values (like resource name), I created my own web service. I used PSI to fetch rates data and used joins for other fields.

    Hope this helps.

    Thanks,

    Vedika Sawant.

    Friday, January 29, 2016 8:32 AM