The customer wants 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: Customer wants 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.
Reproducing the Issue
- Go to 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 (HCMEMPB) as well as other data sources are not available to create a Join Data Source is due to a technical limitation. 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.
The customer can make use of combined conditions to meet his request or as an alternative option, approach the Service Center colleagues in order to raise a new requirement.
In order to get a list of data sources which contains Temporal Join (time-dependent characteristics), we can open the table: MDRS_W_MV_ROOT (transaction se16).
All MDAVs which contains values set for the field TEMP_JOIN_TP into the table, means they are not available for Join in the UI.
The data sources with a temporal join are:
Temporal Join means that the result of the MDAV is dependent on the execution time point which is passed from the query.
Further information can be found in the SAP Library:
KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Product Enhancement