SAP Knowledge Base Article - Public

2346561 - Cannot find key figures while creating join data source


While creating a join or combined data source, you will not find the calculated or restricted key figures which are present in the join members.

Reproducing the Issue

Steps to reproduce:

1. Goto Business Analytics Work Center. 

2. Design Datasources

3. Click 'New' >Combined or Joined data source

4. On the Create Data Source screen, click on Add Data Source and select the data source which you want as join member

Eg: Select "Project Cost and Revenue - Aggregated or Sales Target Plan" and search for key figure 'Counter'

We cannot find it to select.


This is system designed behavior.


The Calculated and Rrestricted key figures present in the join members(i.e data sources used for creating join data source) which can be either standard or custom key figures will not be seen to include in the join data source. The Join Data Source created cannot be calculated correctly and the result consistency cannot be ensured if we enable these keyfigures. Hence, it is possible only to include only the direct key figures coming from the data source. Any such need can be met by creating the key figures on the new join data source created. 


KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Product Enhancement


SAP Business ByDesign all versions ; SAP Hybris Cloud for Customer 1605 ; SAP Hybris Cloud for Customer 1608 ; SAP Hybris Cloud for Customer 1611 ; SAP Hybris Cloud for Customer 1702 ; SAP Hybris Cloud for Customer 1708 ; SAP Hybris Cloud for Customer add-ins 1705 ; SAP Hybris Cloud for Customer add-ins 1711