Symptom
You are trying to make a join story/data source, you are wondering which fields may make a consistent couple of join conditions.
Environment
- SAP Sales Cloud and SAP Service Cloud Version 2
Reproducing the Issue
- Go to User Icon.
- Settings.
- All settings tab.
- Go to Design stories.
- Click on new, Drag and drop data source.
- Click on the two squares icon (link join condition).
- You need to choose data sources and fields to make a couple of fields from different data sources as join condition.
Cause
You will produce an inconsistent custom join data source if you use a couple of fields not equal in semantics.
Resolution
In terms of couple of fields as join condition, the field must be equal, but still can have different labels. Joins work everywhere in the same manner. If the values don't match, then the join will fail. But that doesn't mean that field label need to be same, just the semantics.
The best join conditions must have the same:
- Data type.
- Number of characters.
- The two fields must match, equal to each other.
Keywords
join; conditions; match; data source; story; , KBA , CEC-CRM-ANA , Analytics for SAP Sales/Service Cloud , Problem
SAP Knowledge Base Article - Public