Symptom
Headcount in Story report is different from the Employee Export headcount despite no Role-Based Permissions limitations and no filters applied to the query.
Environment
SAP SuccessFactors People Analytics
Reproducing the Issue
- Create a Story report query with Job Information as the source table for the employees.
- Add a Numeric Widget to count the number of records.
- Compare this number with the number of records in an Employee Export
Cause
Although possible RBP limitations for data visibility and filters to the query may affect the headcount in Story report, the most-likely cause is that you have non-EC users in your system.
This will cause a discrepancy because a Story report based on the Job Information table will only fetch EC users, while the Employee Export will fetch both EC users and non-EC users. I.e.:
- Let's say, for example, you have 10 EC users and 5 non-EC users in your system.
- Since the Employee Export fetches both types of users, the Employee Export will have a count of 15 users.
- And since the Story report beginning with Job Information fetches only EC users, the Story report will have a count of 10 users.
Resolution
This is an expected behavior.
If you need further assistance configuring reports to your business needs, feel free to reach out to your partner, SAP Professional Services, or to post on the SAP Community.
See Also
2978690 - Differences Between Full and Functional Users for an Employee Central License
2584658 - How to Check if a User is an EC User Using the Integration Center - isECRecord Boolean
Keywords
Headcount, Story, report, Employee Export, export, discrepancy, wrong, mismatching, Job Information. , KBA , LOD-SF-ANA-SAC-DAM , Data Modelling - Module & Entity Data Issues , How To