SAP Knowledge Base Article - Public

2727789 - Data Source Cannot be Used as Join Member

Symptom

You are trying to join a HCM or CRM data source with another data source and no data is returned. Also the following error message will occur in HTML5 UI: "Datasource XYZ can not be used as Join Member."

Environment

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. Click Next.
  5. See the error message:  "Datasource XYZ can not be used as Join Member. It uses a temporal join."

* If you use a different UI, like Silverlight, you may be able to save the Join Data Source without errors, however no data will be returned.

Cause

There are few data sources that are not possible to use in join conditions below few examples:


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.

Resolution

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

1827827 - The Data Source is not Available to be Added to a New Joined Data Source

Keywords

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

Product

SAP Business ByDesign 1808 ; SAP Business ByDesign 1811 ; SAP Business ByDesign 1902