SAP Knowledge Base Article - Public

2727789 - Datasource Employee Times HCMTLMU01 Cannot be Used as Join Member

Symptom

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."

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to Business Analytics > Design Data Sources
  2. Find data source HCMTLMU01
  3. Click on New > Join Data Source
  4. 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.

Cause

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.

Resolution

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.

See Also

2366796 - Best Practices for Modelling Data Sources and Reports

1779804 - Report Based on Employee Times Data Source is Timing Out

Keywords

KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To

Product

SAP BUSINESS BYDESIGN 1902 ; SAP Business ByDesign 1808 ; SAP Business ByDesign 1811