Loading
Salesforce now sends email only from verified domains. Read More
About Salesforce Data 360
Table of Contents
Filter by (0)Add
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

            Search all of Salesforce Help
            Search all of Salesforce Help
            Create a Relationship Between Data 360 Objects

            You are here:

            1. Salesforce Help
            2. Docs
            3. Data 360

            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.
             
            Loading
            Salesforce Help | Article