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.

[SnowedIn]

Hi Mehernosh,

I just tried this and it doesn't show the downstream risks/controls if they are not directly for that entity.

I.e. If Etienne wanted to report on Business Unit but all the risks/controls are done at a Business Process level (2 levels downstream), they are unable to see which risks/controls are downstream for the Business Unit level. I believe the Content to Entity table only shows the risks/controls for the entity they are directly against, not any upstream/downstream entities.

Please correct me if I am wrong, I am also trying to figure out how to achieve this reporting.

[Mehernosh Amrol]

May be I misunderstood.  I created the Report using the table and used the list view.  For the Columns I choose these options and then got the Table.

[Etienne Galea M]

Thanks for your replies. I tried various ways of achieving this and basically I could not get what we wanted. In the end we ended up creating a table and a routine which interprets each hierarchy and translates it to a relationship table. My preference would have been reporting on the OOtB tables. The perfect solution would have been if the Database Query supported SQL Union, but................

Do not know if there is a clever way of designing such a report with the current tools.

[Christophe_E]

This may helps:

How to report using our Entity model? - NOWJedi

Regards,

Christophe

[Etienne Galea M]

Thanks for your comment. The only problem is that, from a reporting perspective, I do not want to supply the entity, rather give me the downstream for all entities.