SAP Knowledge Base Article - Public

3258561 - Joined data source shows no results - the join does not work


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.


SAP Cloud for Customer


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.


You can evaluate the following options:

  1. 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"): 
  2. 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.


joined data source, reporting, business analytics, wrong data, missing data, wrong results , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Product Enhancement


SAP Cloud for Customer core applications all versions