SAP Knowledge Base Article - Public

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

Symptom

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.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Business Analytics Work Center.
  2. Go to the View Design Data Sources.
  3. Click on: New | Joined Data Source.
  4. Click on Add Data Source.
  5. Search by HCMEMPB, for instance.

The data source HCMEMPB cannot be found.

Cause

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.

Resolution

You can make use of combined conditions to meet his request or as an alternative option, approach our Service Center Department (servicecenter@sap.com) in order to raise a new requirement and develop a customized solution for you.

The data sources IDs with a temporal join are:

CRMCCOHHB
CRMSLOIHB
CRMSORHHB
CRMSRQHHB
HCMEMPB
HCMPAB01
HCMPAB02
HCMPAB03
HCMPAB04
HCMPAU01
HCMRPMU03
HCMTLMB01
HCMTLMB02
HCMTLMB03
HCMTLMB04
HCMTLMB05
HCMTLMB06
HCMTLMB07
HCMTLMU01
HCMTLMU02
HCMUSPAB01

See Also

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:

http://help.sap.com/saphelp_nw04s/helpdata/en/11/723c3b35703079e10000000a114084/content.htm

Keywords

data source missing, joined data source, HCM data source , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Product Enhancement

Product

SAP Business ByDesign 1711 ; SAP Business ByDesign 1802 ; SAP Business ByDesign 1805