2395975 - Inconsistent result in ORD vs. Excel

SAP Knowledge Base Article - Public

2395975 - Inconsistent result in ORD vs. Excel

Symptom

Report is not producing the same result as it is in ORD when exporting it to excel file.

1.png5.png

Environment

  • Online Report Designer
  • Microsoft Excel

Reproducing the Issue

  1. Go to Analytics and preview the report
  2. Set the runtime filters
  3. Click on "Done"

1.png

     4.    Export the file to Excel using the green icon at the left-hand corner

2.png

    5.    Wait for the report to be on green light in Report Distributor Downloads
    6.    Once the report is ready, download the report

3.png

    7.    Open the report

4.png

5.png

Cause

Exporting the file to Excel using the green icon means exporting the report offline. Thus, the runtime filters that was set up before previewing the file online was not being taken into consideration. Only the filters inside the query (Manage filters) is being respected causing the output in online preview mode and excel file to be inconsistent.

Resolution

Instead of exporting the file using the green icon (which is offline), we should export the file using the options available at the right-hand side of the page if we want the runtime filters to be respected by the report as well.

6.png

Keywords

  • inconsistent records
  • data discrepancy
  • incorrect values
  , KBA , LOD-SF-ANA-ORD , Online Report Designer , Problem

Product

SAP SuccessFactors Workforce Analytics all versions