locked
Report on Project Risks RRS feed

  • Question

  • Hi

    I need a report on Projects Risks.

    I have seen the sample report in BI center but I need something more:

    When a risk is linked to one or more tasks, I need these tasks info like “project Name” and “Task Name”, too.

    How can I make this report in project server 2010? I have required permissions.

    Monday, September 26, 2011 3:47 PM

Answers

  • Hi there,

    Following on from Andrew's great advice, you will need to join to the MSP_WssListItemAssociation table in the Reporting database. You will see a RelatedItemUID, this will be  Item UID that you link the Risk to.

    Edit: You can also the following views:

    MSP_WssRiskToIssueLinks_UserView
    MSP_WssRiskToRiskLinks_UserView
    MSP_WssRiskToTaskLinks_UserView - this is the view you will need for risks to tasks :)

     

    Hope that helps

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com
    • Edited by PWMatherMVP Monday, September 26, 2011 4:31 PM added views
    • Proposed as answer by shelldor23 Monday, September 26, 2011 4:49 PM
    • Marked as answer by Shadi Movahed Saturday, October 1, 2011 9:06 AM
    Monday, September 26, 2011 4:14 PM

All replies

  • You might try a modification of this approach.  There should be a Task ID
    in the database I believe.
     
     
     

    Andrew Lavinsky [MVP] Blog: http://azlav.umtblog.com Twitter: @alavinsky
    Monday, September 26, 2011 3:58 PM
  • Hi there,

    Following on from Andrew's great advice, you will need to join to the MSP_WssListItemAssociation table in the Reporting database. You will see a RelatedItemUID, this will be  Item UID that you link the Risk to.

    Edit: You can also the following views:

    MSP_WssRiskToIssueLinks_UserView
    MSP_WssRiskToRiskLinks_UserView
    MSP_WssRiskToTaskLinks_UserView - this is the view you will need for risks to tasks :)

     

    Hope that helps

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com
    • Edited by PWMatherMVP Monday, September 26, 2011 4:31 PM added views
    • Proposed as answer by shelldor23 Monday, September 26, 2011 4:49 PM
    • Marked as answer by Shadi Movahed Saturday, October 1, 2011 9:06 AM
    Monday, September 26, 2011 4:14 PM