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_SCOREFROM INV_INVESTMENTS IWHERE I.ID = <your ID here>
I also see in my code where I'm calculating it from scratch as Aurora mentions:
SELECTI.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_SCOREFROM INV_INVESTMENTS IJOIN PRJ_PROJECTS PRJ ON PRJ.PRID = I.IDWHERE 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.