Loading
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
            Set Cardinality for Relationships

            You are here:

            1. Salesforce Help
            2. Docs
            3. Data 360

            Set Cardinality for Relationships

            Set the correct cardinality type to define how two objects are related and ensure Tableau Semantics interprets joins accurately. This helps prevent unexpected duplicates or missing data and improves overall query performance.

            Required Editions

            Available in: All Editions supported by Data 360. See Data 360 edition availability.
            User Permissions Needed
            To set cardinality in a semantic model:

            Permission set:

            • Data Cloud Architect

            AND

            Semantic Models object
            1. In Data Cloud or a Tableau Next workspace, go to the Semantic Layer tab and open a semantic model.
            2. Hover over a line connecting two objects to see a summary of the relationship, including the objects involved, the join fields, and the current cardinality type. This quick view lets you confirm the setup before making changes.
            3. Click the line. The Relationship panel opens, showing the fields used for the join.
            4. Choose the appropriate cardinality type from the Cardinality Type dropdown. Your options include One-to-One, One-to-Many, Many-to-One, and Many-to-Many.
              Select cardinality for a relationship
            5. Use the data preview to verify that your choice matches the actual behavior of your data. If you see duplicates or missing values, select a different type that better reflects the real-world relationship.
            6. Click Apply to save your changes.
             
            Loading
            Salesforce Help | Article