SAP Knowledge Base Article - Public

3560386 - Story report and Employee Export headcount discrepancy

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

  1. Create a Story report query with Job Information as the source table for the employees.
  2. Add a Numeric Widget to count the number of records.
  3. 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

Product

SAP SuccessFactors HCM Core 2411