SAP Knowledge Base Article - Public

2644263 - Data missing in specific report - Advanced Reporting

Symptom

  • Data missing in a report that has different objects in the query (e.g. Global Job Information, Compensation, etc)
  • Some employees are not showing up in a specific report

Environment

  • SuccessFactors Workforce Analytics (ANA) - All versions
  • Advanced reporting

Cause

  • The filters defined in the query via Manage Query filter are excluding some employees
  • The Date Options set are not including some employees
  • The join between the tables is set to Inner

Resolution

Filters:

  1. Go to Manage Query Filter
    filter.png
  2. And check if the missing employees match with the defined filter.
    For example, if the filter is "Pay Component" in 25, some employees may be excluded because they have a different Pay component.
    pay filter.png

 

Date Options:

Check if the Date Options match with the missing employees. For example, some employees may have an effective date in future, but the date of the report is set to Current Date. Please find more information on 2368375 - How to Set Up and Use Date Options in Advanced Reporting

 

Join:

If the report has different objects (e.g. Global Job Information, Compensation, etc.), check the join between them to see whether it is set to Inner or to Left.
Depending on what data the employees have in the system, the Inner join may exclude them because there is no data in the object on the right side.

For example, the employees have data in Global Job Information object, but they do not have Compensation data. In this case, if the join is set to Inner (i.e. fetch data that matches both objects only), they will not appear in the result.
Inner.png

Only the employees with data in both objects will show up in the output. So, the solution in this case is to change the join to Left:

Left.png

See Also

2368375 - How to Set Up and Use Date Options in Advanced Reporting

2604712 - User not showing in Global Job Information table - Advanced Reporting

2319401 - Is it possible to have Outer Join between tables in an Advanced Reporting query (REALMS)

Keywords

Data missing report different objects query some employees are not showing up specific user appear do not appearing showing advanced reporting inner join left date option filter , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, ORD) , LOD-SF-ANA-ODS , Advanced Reporting , How To

Product

SAP SuccessFactors Workforce Analytics all versions