Clarity

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?

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

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.

Thanks for your answers. It is greatly helpful.