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