SAP Knowledge Base Article - Public

2343660 - Date difference of one day between the UI data and the one fetched in Table (Ad Hoc) / Canvas (ORD) reports

Symptom

Table (Ad Hoc) / Canvas (ORD) reports show a 1 day (plus/minus) date difference than actual data in the BizX instance.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

SAP Successfactors HXM Suite

Reproducing the Issue

Note the date in the system. Example: Start date of work experience in Employee Profile.

4.PNG

Adhoc Report is showing the date 1 day before the actual date.

1.PNG

Cause

The report is configured to fetch the date/timestamp per the timezone of the logged in user (localized) running the report rather than the server time.

Resolution

Table Reports:

  1. Edit the Report and click the 'Configuration' pill.
  2. Then click the 'DatatType Configuration' option.
  3. Uncheck the 'Localized' checkbox beside the desired field, if you do not want the data to be localized based on the logged in user's timezone.

    Table.jpg

Canvas Reports:
Note: For Canvas reports, the cause and the fix only apply to Detailed Reporting (Live Data) data source.

  1. Edit the Report under concern and choose 'Column Formatting' option from the 'Edit' dropdown.
  2. Then Choose 'TimeStamp' if you DO NOT want the field to be localized.
    Choose 'TimeStamp Localized' only if you want the data to be localized based on the logged in user's timezone.

    canvas.jpg

Keywords

Ad, hoc, Report, 1, day, date, difference, Localized, canvas, table, ORD, one, issue, sync, canvas, server, timezone, locale, local, logged, in, data , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , LOD-SF-ANA-ORD , Online Report Designer , Problem

Product

SAP SuccessFactors HXM Suite all versions