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
Go to Business Analytics > Design Data Sources.
- Find the data source.
- Click on New > Join Data Source.
- Enter a name and click Next.
- Select your fields and complete this step.
- Go to the Joined Data Sources tab and click Add.
- Select another data source which you would like to add to the first.
- 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
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