SAP Knowledge Base Article - Public

2719631 - Adhoc Report data and Dashboard Data are not the same - Reporting

Symptom

Dashboard and Adhoc report does not have the same number of columns on the query.

Environment

  • SAP SuccessFactors Workforce Analytics
  • Adhoc Reporting / Report Table
  • Dashboards 2.0

Cause

Dashboards and Adhoc pulls the same information from the data base so the information cannot be different. This is usually caused because the configuration of the both tool are different.

Resolution

Please see below all the configuration between the two tools that have to be checked and can occur of having a different results.

  1. The first thing that it is required to check is it is the same user that it is running both tool;
  2. The second steps are to check if the people scope is the same and also if the inactive users check box is marked.
    Adhoc:

    2018-11-15_10-41-43.png
    Dashboard:
    2018-11-15_10-50-11.png
  3. The third thing that have to be check is if the data sets are the same selected;
    Adhoc:
    2018-11-15_10-51-41.png
    Dashboard:
    The data set for dashboards is showed on the first screenshot.
  4. Check what type of calculation it is being used on the "Chart Data". It may have to be changed depending on the fields selected;
    2018-11-15_10-52-53.png
  5. Check if the same columns are selected on the report and if the enable distinct is selected;
    Adhoc:
    2018-11-15_10-53-47.png
    Dashboard:
    2018-11-15_10-57-20.png
  6. The last step is to confirm if the dashboard or the adhoc report has any filters.
    Adhoc:
    2018-11-15_10-58-37.png
    Dashboard:
    2018-11-15_10-59-11.png

Keywords

Dashboard - tile - adhoc report - Same information - Diferent - Configuration , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, ORD) , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , LOD-SF-ANA-DSH , Dashboard and YouCalc , Problem

Product

SAP SuccessFactors HCM Core all versions ; SAP SuccessFactors Workforce Analytics all versions