Guardrail needed to prevent creating a chain of more than a CDP Calculated Insights
Trailblazer Community

Guardrail needed to prevent creating a chain of more than a CDP Calculated Insights

CDP

Last updated 2022-05-20 ·Reference W-11071264 ·Reported By 0 users

In Review

Summary
When you create a Calculated Insight, you are able to reference fields from another Calculated Insight in your SQL statement. As you reference Calculated Insights in this way, you can create a chain with multiple layers of Calculated Insights.

As per the Salesforce CDP product team we do not support a chain of more than 3 layers of Calculated Insights.

For example, the following should be the most layers possible:

Calculated Insight A

SELECT ... FROM

Calculated Insight B

SELECT .. FROM

Calculated Insight C

If a Calculated Insight is at the limit of 3 it should not be visible in the Insights list when creating a new Calculated Insight. However, it has been observed that it is possible to bypass this guardrail by manually writing the SQL statement and selecting from any Calculated Insight using its API Name.

Repro
Follow these steps to create a Calculated Insight in Salesforce CDP:
-Navigate to Calculated Insights tab
-Click New button
-Click Create with SQL
-Instead of selecting the Calculated Insight you want to query from the Insights list, manually write your SQL and using any Calculated Insight's API Name in the FROM or JOIN condition.

Note: this is not prevented by a guardrail and therefore allows more layers of Calculated Insights than intended.

Workaround
No workaround currently to prevent bypassing this limitation by manually writing the SQL.

Reported By (0)

Any unreleased services, features, statuses, or dates referenced in this or other public statements are not currently available and may not be delivered on time or at all. Customers who purchase our services should make their purchase decisions based upon features that are currently available.