Overview

Table relationships define how data is one table relates to data in another table. This is extremely important within Cosmos reports because having these relationships set makes it much easier for business users to create reports because they are required to know much less about the underlying data model. This article covers how to set relationships between tables in the Data Model.

Details

To define relationships between tables, navigate to the Data Model section of the Cosmos Portal and go to the reporting tables. You will then click on the table that you'd like to add a relationship for on the left and click on the Relationships tab.

To add a new relationship, click the + to the right of the Relationships label. You will then see an Add Relationships window. Type in the name of the new relationship, specify the Target Table to set the relationship to, and then set the join criteria between the two tables.