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."
SAP Business ByDesign
Reproducing the Issue
Go to Business Analytics > Design Data Sources.
- Find the data source.
- Click on New > Join Data Source.
- Click Next.
- 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.
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
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.
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