Clarity

Expand all | Collapse all

"Calculated Risk" field in Clarity Risk Page

Jump to Best Answer
  • 1.  "Calculated Risk" field in Clarity Risk Page

    Posted 12-14-2016 06:15 AM

    I need to display the "Calculated Risk" attribute value which is available in Clarity Risk page, in an NSQL query based portlet. I checked in the Risk Object but the calculation is not available there. How can I calculate the "Calculated Risk" value?



  • 2.  Re: "Calculated Risk" field in Clarity Risk Page

    Posted 12-14-2016 07:26 AM

    You will have to calculate it in your NSQL based on your configured risk factors and risk matrix.



  • 3.  Re: "Calculated Risk" field in Clarity Risk Page
    Best Answer

    Posted 12-14-2016 01:06 PM

    With the PMO Accelerator there's a Function:

    SELECT
    I.NAME
    , I.ID
    , NIKU.COP_RISK_FCT('PROJECT', I.ID) RISK_SCORE
    FROM INV_INVESTMENTS I
    WHERE I.ID = <your ID here>

     

    I also see in my code where I'm calculating it from scratch as Aurora mentions:

    SELECT
    I.NAME
    , I.ID
    , ((PRJ.RCF_OBJECTIVES+PRJ.RCF_SPONSORSHIP+PRJ.RCF_FUNDING+PRJ.RCF_RESOURCE_AVAIL+PRJ.RCF_INTERDEPENDENCY+PRJ.RCF_TECHNICAL+PRJ.RCF_HUMAN_INTERFACE+PRJ.RCF_ORG_CULTURE+PRJ.RCF_SUPPORTABILITY+PRJ.RCF_IMPLEMENTATION+PRJ.RCF_FLEXIBILITY)/11)  RISK_SCORE
    FROM INV_INVESTMENTS I
    JOIN PRJ_PROJECTS PRJ ON PRJ.PRID = I.ID
    WHERE I.ID = <your ID here>

     

    If I recall right (which I obviously don't), there's a couple more views & other ways to get at this.



  • 4.  Re: "Calculated Risk" field in Clarity Risk Page

    Posted 12-19-2016 08:02 AM

    Thanks for your answers. It is greatly helpful.