SAP Knowledge Base Article - Public

2116784 - Why are there sometimes duplicate records for an employee, in the Drill to Detail (DTD)? - Platform Services & Tools

Symptom

  • Why are there sometimes duplicate records for an employee, in the Drill to Detail results display? 

Problem

  • As a User/Admin, you may see multiple records for one employee when you have drilled into the data.  This can be normal, depending on the data involved.

 

Environment

  • Platform Services & Tools

Cause

  • The selection of time period, in the query, is important to consider. 
     
  • Measures that are based on a 'point in time' will return multiple records. for each period they are valid.  An example being 'EOP Headcount' for a quarter will return a record for each month the employee was available. (See Table 1 below in 'Solution').
     
  • If an employee records an 'Internal Movement' a further headcount record may appear, dependant on the underlying data provided and the data processing required. (See Table 2 in 'Solution').

Resolution

  • To ensure that the underlying records, that contribute to the result displayed onsite are clearly identified, an additional column of data will be added to the Drill to Detail results display to show the value that the individual record contributes towards the result total.
Table 1
Date EmployeID OrgUnit Age Gender
01/01/2012 446566 Finance 38 F
01/02/2012 446566 Finance 38 F
01/03/2012 446566 Finance 38 F
  • Table One shows why there are multiple records for the quarter time period.  Showing one record for each month in the quarter.
     
Table 2
Date EmployeID OrgUnit Age Gender EmpStatus
01/01/2012 446566 Finance 38 F Full Time
01/02/2012 446566 Finance 38 F Full Time
15/02/2012 446566 Accounting 38 F Part Time
01/03/2012 446566 Accounting 38 F Part Time
  • In Table Two, this example is driven by two items, a change in Organisational Unit, and  a change in Employment Status.  This would not be a complete picture without the addition of the EmpStatus table, the user would just see two records for the month of February and assume that it is just an 'Internal Movement'.
     
     
  • When initially setting up Drill to Detail is is important to consider the level of information the end user will need to see.  The existing columns can be amended if required.  Please contact the support team for assistance with this.

Keywords

KBA , LOD-SF-PLT , Foundational Capabilities & Tools , Problem

Product

SAP SuccessFactors HCM Core all versions