none
Separate Resource Reporting Using Project 2010 RBS RRS feed

  • Question

  • Hi, We recently upgraded to Project Server 2010 and have found the reporting to be much more complicated than in 2003! We used to be able to easily filter or group resource reports by the RBS and we are unable to figure out how to do this through the Business Intelligence templates provided. Could someone please help? 
    Wednesday, March 20, 2013 2:39 PM

All replies

  • Irish Gues --
     
    Here is one way to create a report that shows the total Work by resource and by project over time:
     
    1.  Create a new BI Center report using OlapPortfolioAnalyzer cube.
    2.  In the PivotTable Field List sidepane, set up your report similar to the following:
    • Drag the RBS Resource dimension to the Report Filter drop area.
    • Drag the Resource List dimension to the Row Labels drop area.
    • Drag the Project List dimension below the Resource List dimension in the Row Labels drop area.
    • Drag the Time dimension to the Column Labels drop area.
    • Drag the Work total field to the Values drop area.
    When you save the resulting BI Center report, users can select an RBS value in the Report Filter pick list.  Hope this helps.

    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    Wednesday, March 20, 2013 4:29 PM
    Moderator
  • Hi Dale,

    Thanks... the issue is that I don't have RBS Resource available to me in the pivot table field list. (Sorry, should've made that clear...) Any idea how to get it there?

    Wednesday, March 20, 2013 4:39 PM
  • Irish Gues --
     
    Thanks for the clarification.  Click Server Settings > OLAP Database Management.  In the Server Name column, select the OLAP database, and then click the Configuration button.  In the Cube Dimensions section of the Database Configuration page, click the Cube pick list and select the Resource item.  In the Available Fields list on the left, select the RBS_Resource dimension and then click the Add button.  Click the Save button and then click the Build Now button to completely rebuild the OLAP cubes.  You should now see the RBS_Resource dimension as you build BI Center reports using the OLAP cubes.  Hope this helps.
     

    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    Wednesday, March 20, 2013 4:50 PM
    Moderator