You are trying to create a custom Data Source using a data source that contains certain customized key figures, however, the customized key figures are not showing up for selection in the data source.
Reproducing the Issue
- Go to the Business Analytics work center and access the view Design Data Sources;
- Click on New and choose one of the two options: Combined Data Source or Joined Data Source;
- On the Create Data Source screen, click on Add Data Source and select one of the data sources you want to use;
- When you check the Key Figures for the selected data source, you will see that all customized key figures are not available.
This is a known limitation on the system. As the key figures are created based on a specific data source, created key figures are only available for the data source which was created upon.
If you wish to have your customized key figures in a new custom data source, you will have to create the key figures in the new data source.
KBA , SRD-FIN-ERM , Travel and Expense Management , How To