Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Report on Project Risks RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote
    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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