Create data relationships
Create a path to go from a record in the template configuration to any table that you require. When you create these paths, you can get the necessary data from each of these paths in your audit report template.
Before you begin
Role required: sn_grc_doc_design.admin and sn_audit.admin
About this task
When you create data relationships, for example, for an audit engagement, you can specify how the issues, remediation tasks, test plans, and so on, are related to the record in the template relationship registry and you create a path to navigate to these respective records. You can create as many relationships as you require.
Procedure
Navigate to All > Audit > Audit Report > Template configurations.
Open the template configuration that you created.
In the Data relationships related list, select New.
On the form, fill in the field.
| Field | Description |
|---|---|
| Name | Level that you want to go to. For example, you can specify `Engagement to issues`. |
| Source | |
| Parent relationship | Parent of the data relationship. |
| Source table | Source table used for the data relationship created. This field is automatically set. |
| Target | |
| Target relationship | Select an existing relationship or create a target relationship. For example, you can select Issues to engagement. Note: For more information, refer to Setting up the 360º views. You can register only existing relationships between the types of data you want to view. |
| Relationship type | Type of the relationship such as many to many or one to many. This field is automatically populated based on the selection made in the Target relationship field. |
| Target table | Table from which the data is obtained. This field is automatically populated. |
- Select Submit.
What to do next
Create content configurations to specify the type of data you want to fetch on the report. For more information, see Create content configurations.