You want to create a join model between two or more data sources, however the data source desired is not available for selection by clicking on Add Data Source button.
Example of use case: You want to create a Joined data source between HCMRPMU01 and HCMEMPB, HCMRPMU01 is available but HCMEMPB cannot be found and simply it is not available to create a Joined Data Source.
SAP Business ByDesign
Reproducing the Issue
- Go to the Business Analytics Work Center.
- Go to the View Design Data Sources.
- Click on: New | Joined Data Source.
- Click on Add Data Source.
- Search by HCMEMPB, for instance.
The data source HCMEMPB cannot be found.
The reason why the Employee Master Data (ID: HCMEMPB) as well as other data sources are not available to create a Join Data Source is due to a technical designing. There are some data sources which use Temporal Joins to map a period of time (time-dependent characteristic) and hence, it is technically impossible to create a join condition.
Joined Data Sources on top of temporal joins were never supported.
You can make use of combined conditions to meet his request or as an alternative option, approach our Service Center Department (email@example.com) in order to raise a new requirement and develop a customized solution for you.
The data sources IDs with a temporal join are:
Temporal Join means that the result of the Data Source is dependent on the execution time point which is passed from the query.
Further information can be found in the SAP Library:
data source missing, joined data source, HCM data source , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Product Enhancement