Compute Summary Node Rollups from Externally Imported Flexible Hierarchy Data
To update flexible hierarchy node summary records, import node contribution values from an external system. Then use a Data Processing Engine (DPE) definition to calculate and roll up child and total aggregate values across the hierarchy.
Required Editions
Available in: Lightning Experience Available in: Unlimited and Agentforce Editions |
| User Permissions Needed | |
|---|---|
| To import data and create Data Processing Engine definitions: | Modify All Data AND Customize Application and Modify All Data system permissions AND Flexible Hierarchy Admin |
- When you import external records, map each record to its corresponding node by using the Flexible Hierarchy Node ID.
- If you import flexible hierarchy node summary records that have all field values populated, the node value, child aggregate value, and total value appear in the hierarchy builder without requiring you to run a DPE definition.
Use Data Processing Engine definitions to roll up imported data across the hierarchy when the external system can't compute child aggregate values. For example, an asset management system exports fund subscriptions and redemptions for each entity but doesn't know how those entities are structured in the hierarchy. To roll up the imported data across the hierarchy when the external system can't compute child aggregate values, build a Data Processing Engine definition.
- Confirm that a flexible hierarchy with active nodes exists in Salesforce.
-
Import the node contribution values from your external system into the Flexible Hierarchy
Node Summary object by using Data Loader or APIs.
To compute summary rollups, make sure that the hierarchy ID in the external data matches the flexible hierarchy ID.
- Create a Data Processing Engine definition to compute the rollup values.
- (Optional) Clone and customize the predefined DPEs.
-
Save and activate the Data Processing Engine definition.
Note If rollup values are null, make sure that the NodeMeasureType value that the Data Processing Engine definition writes matches both a picklist value in the Node Measure Type field on the flexible hierarchy node summary object and the summary rollup metric on the hierarchy type. -
Run the definition manually, or schedule it to run automatically.
To keep rollup values current as the external system provides updated data, use a schedule-triggered flow to run the definition at regular intervals. For example, if your banking system exports account balances nightly, schedule the definition to run after the import completes.
-
Verify that the rollup metrics appear correctly in the hierarchy.
Open the hierarchy in the Graph or Grid view, and click a node to view its rollup metrics.
After you run the definition, the rollup metrics for each node appear in the hierarchy in Graph or Grid view. Child aggregate values and total values reflect the imported node contribution data.
See Also
- Salesforce Help: Create and Deploy Data Processing Engine Definitions to Compute Summary Rollups for Flexible Hierarchies
- Salesforce Help: Explore the Roll Up Account and Contact Opportunities Data Processing Engine Definition
- Developer Documentation: Flexible Hierarchy Node Summary Object Fields
- Salesforce Help: Example: Calculate Net Fund Flow Rollups for Flexible Hierarchy Summary Records
