What is the difference between risk and sn_risk_risk tables?

arielgritti
Mega Sage

Hi community,

 

I saw that using the Risk Register the "risk" is created in the "sn_risk_risk" table.

If you create a risk from SPM (project) the "risk" is created in the risk table.

What is the difference? How those tables/processes are related?

 

Thanks,

Ariel

8 REPLIES 8

Community Alums
Not applicable

HI @arielgritti ,

Yes, you need to have Advanced Risk Management first , you need to have integration of Project Portfolio Management with Integrated Risk Managementthen and Enable the property "Enable Advanced Risk PPM Integration".

 

Hi Sandeep,
Thanks for another helpful feedback/answer. This make sense now.
I'll try it in my PDI before moving forward in our instances. IIRC enabling Advanced Risk Mgmt isn't reversible.

In case I found your answer is correct, I'll mark it.
Thanks,
Ariel

Community Alums
Not applicable

Great😀

Hi Sandeep,

 

Last update on this topic. Unfortunately, I believe that Advanced Risk Assessment doesn't cover our business case. Correct me if I'm wrong, but enabling ARA in conjuntion with PPM to manage projects risks will still creating the risks associated to the project in the "risk" table. What changes is the way we assess those risks, obviously using ARA instead of classic assessment.

 

But if you create a risk by Risk Register it's created in the sn_risk_risk table.

 

Our business case is to manage "all" risks in one-place (preferible a unique table) and to have the possibility to "mark in anyway" some of them as "enterprise" risk to trigger another related/internal processes.

That restriction and the fact we should move from IRM Professional to IRM Enterprise if we want to integrate PPM with RM is acting as a blocker for us.

Any suggestion? The questions isn't only for you, it's for the forum/community.
Am I missing something?

Thanks,
Ariel