cancel
Showing results for 
Search instead for 
Did you mean: 

Not able to Join Employee Times Datasource and Project Datasource.

0 Kudos

Hi Experts,

I was trying to create a joined DS from Employee Times (HCMTLMU01) and Project (PROPRJB).
The system was throwing an error as " Datasource HCMTLMU01 can not be used as Join Member. It uses a temporal join."

Can we have any other work around to do this?

Accepted Solutions (0)

Answers (1)

Answers (1)

lokesh2
Advisor
Advisor
0 Kudos

Hi Praveen,

Currently, HCMTLMU01 ( Employee times ) is a temporal join data source, which uses characteristics 'key date' as the key member of its Query and cannot be used for join data sources as it would effect the overall result once the Query is fired.

Considering the scenario where this data source was enabled to be used in joins, we would have inconsistent results due to the dependency of HCMTLMU01 with its query element and the dependency on temporal element. As most of the joins considering HCM scenarios with Time x. Any other units is not measured by dates, we would certainly have misleading results once such customized data source would be used.

Therefore, it was decided that Datasource HCMTLUM01 cannot be used as Join Member as it uses a temporal join. however it can still be used for combined data sources.

In case you are looking for specific customization, you can contact service center ...servicecenter@sap.com

Additional information, The data sources that currently contain temporal joins in the system

CRMCCOHHB

CRMSLOIHB

CRMSORHHB

CRMSRQHHB

HCMEMPB

HCMPAB01

HCMPAB02

HCMPAB03

HCMPAB04

HCMPAU01

HCMRPMU03

HCMTLMB03

HCMTLMB01

HCMTLMB02

HCMTLMB03,04,05,06,07

HCMTLMU01,02

HCMUSPAB01.

Thanks

Lokesh Sharma