Loading
Connect in real time with the Trailblazer Community in Slack Open BetaRead More
Compute Summary Node Rollups from Externally Imported Flexible Hierarchy Data

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.

Note
Note Build your own definition or clone and customize an existing predefined definition to match your data source.
  1. Confirm that a flexible hierarchy with active nodes exists in Salesforce.
  2. 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.

  3. Create a Data Processing Engine definition to compute the rollup values.
  4. (Optional) Clone and customize the predefined DPEs.
  5. Save and activate the Data Processing Engine definition.
    Note
    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.
  6. 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.

  7. 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.

 
Loading
Salesforce Help | Article