none
Project Server 2013 and Standard Rates RRS feed

  • Question

  • I know this question has been asked regarding earlier versions of MSPS, but was wondering if someone familiar with 2013 could answer it in regards to that version.  In 2013, is there a way to "hide" standard rates from "unauthorized" personnel?  The organization I work in allows limited access to the rates charged per labor category (tied to individual contract resources) to a handful of personnel - which doesn't include most PMs.  We're currently using MSPS 2010.  We extract assignment data with actual/planned hours into a spreadsheet using a SQL query.  The spreadsheet has a worksheet that contains rates for each contract company/labor category.  We match the labor category to the labor category of each resource in the assignment data we're pulling from MSPS and calculate a "real" cost in the spreadsheet (using the VLookup function in Excel) and then roll up using a pivot table.  That works okay, but would still be easier if we could do it in MSPS without the extra step.  Unfortunately, in 2010, there is no way to hide the rate info from PMs using Project Pro because they can simply open the resource sheet in Pro and see the rates. 

    Is there any new functionality in 2013 that would allow us to do this without the separate spreadsheet?

    Thanks - DKLJoe

    Friday, August 23, 2013 8:04 PM

Answers

  • DKLJoe --

    No, there is no new functionality in Microsoft Project 2013, whether used with our without Project Server 2013, that will allow you to hide the resource rates from your PMs.  If the resource rate information is specified for the resources in your Enterprise Resource Pool, this means that your PMs can see the information.  Hope this helps.


    Dale A. Howard [MVP]

    • Marked as answer by DKLJoe Wednesday, August 28, 2013 7:55 PM
    Saturday, August 24, 2013 7:21 PM
    Moderator

All replies

  • DKLJoe --

    No, there is no new functionality in Microsoft Project 2013, whether used with our without Project Server 2013, that will allow you to hide the resource rates from your PMs.  If the resource rate information is specified for the resources in your Enterprise Resource Pool, this means that your PMs can see the information.  Hope this helps.


    Dale A. Howard [MVP]

    • Marked as answer by DKLJoe Wednesday, August 28, 2013 7:55 PM
    Saturday, August 24, 2013 7:21 PM
    Moderator
  • Thank you Dale.

    Wednesday, August 28, 2013 5:15 PM
  • Like Dale said there is no way to hide this within Project Server 2013. However, you could use Excel 2013 with PowerPivot to simplify the reporting a bit. You could pull data from one source that has the rates and join that on a query with resources in Project Server and have that combined in the same Excel workbook for reporting. A little easier than the current vLookup method you are using today. Then you could use SharePoint security to lock down the Excel workbook that is saved in SharePoint.
    Friday, August 30, 2013 7:55 AM