How can we create a report showing all the downstream risks and controls from an Entity.

[Etienne Galea M]

Example of Entity hierarchy: Business Unit - Department - Business Process -> Risk

We would like to create a report on the Business Unit level showing all the downstream Risks which can link directly to the Business Unit or indirectly (e.g. Business Process), keeping in mind that a report cannot be grouped using a List field.

[Community Alums]

Hi @Etienne Galea M ,

If you look at a Entity Record, there is no Business unit as such , however what you can use is the "Department"

So, what you can create is , using the sn_grc_profile table is below:

[Etienne Galea M]

Hello Sandeep,

Thanks for you reply. As much as I like that idea, I would still have an issue when I have multiple departments somewhere down the hierarchy for a given entity. We would like to report the issues under all departments grouped by the parent. So, for example, I might have:   Parent > D1

                                                                                                         > D2

                                                                                                         > D3

All issues under D1 D2 and D3 need to be reported grouped by Parent

[SnowedIn]

Hi Etienne, did you figure out a solution to this?

I am currently trying to achieve the same thing, although on the upstream entity record I can see all the downstream risks and controls, there is no filter or anything present so I can't seem to get those risks/controls in a report for a dashboard.

What did you end up doing?

Thanks

[Mehernosh Amrol]

Use the "Content to Entity" table.  Then you can filter on the Entity and it will show you the Risks and Controls Associated.