- 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.
- Platform Services & Tools
- 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').
- 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 One shows why there are multiple records for the quarter time period. Showing one record for each month in the quarter.
- 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.
KBA , LOD-SF-PLT , Foundational Capabilities & Tools , Problem
SAP SuccessFactors HCM Core all versions