Symptom
Data source HCMTLMU01 shows triple records for an employee although there is only one time entry in the time sheet of the issued employee.
Environment
SAP Business ByDesign
Reproducing the Issue
- Open the time sheet of the employee.
- Create one time entry with start and end time.
- Go to Business Analytics - Design Data Sources.
- Preview data source HCMTLMU01.
- Filter the employee.
- Set the view as Start Time, End Time, Date, Employee and Record Time.
- Three entries display.
Cause
This is the default system behavior. In data source HCMTLMU01, there are two predetermined entries displayed without recording any time entry. One is a valuation result time which shows the total time of recording. The other is a default value and the date from and to will be hire date to Unlimited (termination date) of the time profile.
Resolution
If it is no need to use the default records, filter the start time and end time as Not equal to (!=) 00:00:00. Then, these two records will be filtered, and only recorded times with start and end time maintained will be available.
Keywords
Triple Records, Data Source, HCMTLMU01, Timesheet Entry , KBA , SRD-HR-ANA , Analytics Content , Problem