SAP Knowledge Base Article - Public

2727789 - Data Source Cannot be Used as Join Member


You are trying to join a HCM or CRM data source with another data source but you receive the following error message "Datasource cannot be added. Temporal Joins are only allowed as Anchor."


SAP Business ByDesign

Reproducing the Issue

  1. Go to Business Analytics > Design Data Sources.
  2. Find the data source.
  3. Click on New > Join Data Source.
  4. Enter a name and click Next.
  5. Select your fields and complete this step.
  6. Go to the Joined Data Sources tab and click Add.
  7. Select another data source which you would like to add to the first.
  8. See the error message:  "Datasource cannot be added. Temporal Joins are only allowed as Anchor."


There are few data sources that use temporal joins. Such data sources can only be used as the anchor data source.

The data sources with temporal joins are:

Employee Turnover HCMPAU01

Employee Times HCMTLMU01

Employee Master Data HCMEMPB

Service Request History CRMSRQHHB

Headcount HCMPAB01

Actual Utilization HCMRPMU03

Employee Recorded Times HCMTLMB07

Employee Time Accounts HCMTLMU02

The reason why is because it uses a characteristic as a temporal key member of its query, and therefore it cannot be used for Join Data Sources as it would affect the overall result once the query is executed.


You can use the data sources that have this particular characteristic to create a combined data source with another application data source. However, this will very likely result in performance issues due to huge data processing, eventually leading to time out dumps. Applying very specific filtering in report level would be mandatory in this scenario, but according to the total system data amount this may still result in time out issues.

See Also

2366796 - Best Practices for Modelling Data Sources and Reports

1779804 - Report Based on Employee Times Data Source is Timing Out


Employee Turnover HCMPAU01, Employee Times HCMTLMU01, Employee Master Data HCMEMPB, Cannot join data source, error join, a temporal join. , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To


SAP Business ByDesign all versions