Triangle object relationships

A triangle object relationship exists when one child has two parents that are related to each other. To enhance report authoring capability, use the Supported Triangle Relationships setting to configure object types with triangle relationships in the Reporting Framework V6 relational data model. V6 refers to the latest framework version, not to any specific OpenPages release number.

Within the triangle, the "top" (parent 1) and "bottom" (child) object types are non-recursive, with the "middle" (parent 2) object type being recursive (such as Sub-Process).

A triangle relationship that includes two recursive object types is not supported.

For example, a report author has a requirement to create a Risk report that allows business users to assess risks associated with various processes and sub-processes within their company.

To provide the report author with easier reporting capability in the framework model, you could configure a triangle relationship between the non-recursive child Risk object and its two related parents: a non-recursive parent Process object and a recursive parent Sub-Process object type, as shown in Figure 1.

Figure 1. Triangle relationship between objects
Process box points to Sub-process box and Risk box. Sub-process box points to Risk box.

The path between the objects forming a triangle relationship must be reflected in a namespace within the reporting framework. For example, a namespace might have the following object type hierarchy configured for Business Entity, Process, Sub-Process, and Risk object types as follows:

SOXBusEntity|SOXProcess,SOXProcess|SOXSubprocess,SOXSubprocess|SOXRisk

To reflect the triangle relationship shown in Figure 1, that namespace would have to be modified to also include the path between Process and Risk objects as follows:

SOXBusEntity|SOXProcess,SOXProcess|SOXSubprocess,SOXProcess|SOXRisk,
SOXSubprocess|SOXRisk

Without the configured triangle, the report author would have to use advanced techniques that may not perform as well to accomplish this task.

To configure triangle object relationships, see Setting the triangle reporting framework object relationships.