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 HCM Suite
  • Adhoc Reporting / Report Table
  • Dashboards 2.0

Cause

Dashboards and Adhoc is pulling the same information from the data base. If you see a difference between Ad Hoc and Dashboard, it is  caused by differences in the configuration between them.

Resolution

Bellow the configuration differences between the two tools that have need to be checked:

  1. Verify that the same user is running both tool.
  2. Check if the people scope uses the same setting and 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. Check if the data set selection is the same:
    Adhoc:
    2018-11-15_10-51-41.png
    Dashboard:
    The data set for dashboards can be seen 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 "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, YouCalc, ORD) , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , LOD-SF-ANA-DSH , YouCalc Dashboards and Tiles (Dashboards 2.0) , Problem

Product

SAP SuccessFactors HXM Suite all versions