Salesforce Docs Portal

Create a Relationship Between Data 360 Objects

You can create a relationship between any two Data 360 objects in a semantic model.

Required Editions

Available in: All editions supported by Data 360. See Data 360 edition availability.
User Permissions Needed
To create a relationship:

Permission set:

  • Data Cloud Architect

AND

Semantic Models object
  1. In Data Cloud, on the Semantic Layer tab, select a data model.
  2. In the Semantic Model Builder Canvas, click the plus sign next to the first object.
  3. From the dropdown select the object you’re creating a relationship for.

    New SL relationship

    The bottom panel opens. Here you can configure the relationship.

    Creating SL relationship

  4. To properly configure a relationship, you must select matching data object fields.
  5. In the bottom panel, select the plus icon under Select data object fields.
  6. Select the matching data object fields for the objects.
    The data object fields must be of the same type. You can search for fields by entering keywords in each box.
  7. Click Add.
  8. Select the plus sign and repeat the process to add matching data object fields.
    After the relationship is configured, you must save it to maintain its configuration.
  9. Click Apply.
    The bottom panel displays a preview of all the fields within both data cloud objects.

    SL relationship preview

    A black line indicates that the relationship is configured correctly.

    SL relationship in canvas

You can use a calculated field in a relationship, but only under specific conditions:

  • The calculated field must reference only fields from the data object being connected, both in its formula and filters.
  • If a calculated field references another calculated field, the referenced field must follow the same rule.
  • If the calculated field is a measure, it can't include any aggregation methods.
Important
Important When querying relationships, Tableau Semantics determines the join type based on the relationship and context of the query. To configure the join type manually, use logical views. See Logical Views.