Symptom
You have joined 2 data sources but you find that the join does not work. The new data source shows no data (in case of an inner join) or partial data (in left outer joins).
You have checked the join conditions, and the fields used for joining are the same data type and show the same information. The check is successful.
Environment
SAP Cloud for Customer
Cause
The join is failing for this data source as the length of the data type of fields in the join condition is more than 60 characters.
By default, analytics framework supports a length of 60 characters only. Due to this, the values extracted from the join field get truncated to 60 and the join fails. We are currently working to find a permanent solution to this, however this will be a long term enhancement.
Resolution
You can evaluate the following options:
- Turn on extended character support in Analytics the business configuration. You would need to do this in all your systems. The required setup is described here (Step 1 a - g under "Procedure"): https://help.sap.com/docs/SAP_CLOUD_FOR_CUSTOMER/66e9a9081a7b40e38c8604d6617d0311/491225974c0d41e3bb48ba9fd6bab4c2.html?locale=en-US
- Change the join condition in this data source, so that it is joined on a field containing less than 60 characters. Different join conditions may affect the result of this data source, so you would need to consider if this change works for your requirement.
Keywords
joined data source, reporting, business analytics, wrong data, missing data, wrong results , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Product Enhancement