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
            Special Handling of DMO Relationships in Data Graphs

            You are here:

            1. Salesforce Help
            2. Docs
            3. Data 360

            Special Handling of DMO Relationships in Data Graphs

            Data model object (DMO) relationships can affect how data is processed and reflected in data graphs, particularly in real-time data graphs. Review DMO relationship types when designing data graphs to make sure that processing behavior aligns with your expected update patterns.

            Required Editions

            Available in: All Editions supported by Data 360. See Data 360 edition availability.

            Real-time data graphs support 1:1 and 1:N DMO relationships. An N:1 relationship occurs when multiple child records reference a single parent record. For example, consider the relationship between sale order products and product categories. A sale order can contain multiple products, and each product in the order is represented as a sale order product record. Each sale order product is associated with a product category, such as Electronics or Fashion. A single order might include an iPhone and AirPods, which both belong to the Electronics category, and a T-Shirt, which belongs to the Fashion category.

            In this scenario, multiple sale order product records reference the same product category record. For example, both the iPhone and AirPods sale order product records reference the Electronics product category. This relationship represents an N:1 relationship, where many child records map to one parent record. The child record’s foreign key (product category ID) points to the parent record’s primary key, allowing multiple child records to reference the same parent record.

            Consider these two scenarios of N:1 relationship support based on when the real-time data graph was created.

            • New real-time data graph behavior: Newly created or edited real-time data graphs don’t support N:1 relationships. If adding a DMO introduces an N:1 relationship, the system blocks the selection during creation or editing.
            • Existing real-time data graph behavior: Real-time data graphs that were created before this restriction was introduced may already include N:1 relationships. These graphs continue to run for backward compatibility. However, changes to the parent DMO in an N:1 relationship aren’t immediately reflected in related records within the real-time data graph. Updated values become available only after the data graph is rebuilt or refreshed according to its configuration.

            This restriction applies only to newly created real-time data graphs. Standard data graphs continue to support N:1 relationships.

            See Also

             
            Loading
            Salesforce Help | Article