SAP Knowledge Base Article - Public

3684768 - Wrong date when exporting to Excel in Data Analyzer since QRC4

Symptom

  • When exporting to Excel in Data Analyzer, the dates displayed are not the same than in Insight report based on a BW query with live connection: the date field shows one day earlier.
  • For example, the date displayed in Insight report is 2025-11-15 and, if the Exported to Excel file is done in a different timezone (for example US timezone), the date is displayed as 2025-11-14.
  • The issue is NOT reproduced when exporting to CSV or PDF the same Insight report.

Environment

SAP Analytics Cloud version 2025.21.5

Reproducing the Issue

  1. In Data Analyzer, open an Insight report based on a BW query
  2. Choose Excel Export
  3. Check the dates in the Excel file

Resolution

The next QRC4 2025 patch is expected to be released this weekend.
The build number of that patch will be 2025.21.6 and it will contain the correction for this issue.

Keywords

KBA , LOD-ANA-DAN , SAC Data Analyzer , Known Error

Product

SAP Analytics Cloud all versions