You are trying to join the data source Employee Times with another data source and no data is returned. Also the following error message will occur in HTML5 UI: "Datasource HCMTLMU01 can not be used as Join Member."
SAP Business ByDesign
Reproducing the Issue
Go to Business Analytics > Design Data Sources
- Find data source HCMTLMU01
- Click on New > Join Data Source
- See the error message: "Datasource HCMTLMU01 can not be used as Join Member"
* If you use a different UI, like Silverlight, you may be able to save the Join Data Source without errors, however no data will be returned.
The data source HCMTLMU01 (Employee Times) is a temporal join Data Source,
which uses characteristic "Key Date" as the key member of its query, and therefore it
cannot be used for Join Data Sources as it would affect the overall
result once the query is executed.
You can use the data source Employee Times as Combined data source with another application data source. However, this will very likely result in performance issues due to huge data processing, eventually leading to time out dumps. Applying very specific filtering in report level would be mandatory in this scenario, but according to the total system data amount this may still result in time out issues.
KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To