SAP Knowledge Base Article - Public

2763395 - Timestamp and date filter values localised in reports - Ad Hoc/Table


Are the timestamp and date filter values localised in reports?

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


SAP SuccessFactors HXM Suite

Reproducing the Issue

  1. Log in to  the instance with a user in the same timezone of the server
  2. Create a report in Adhoc with a timestamp field e.g. Form Creation Date
  3. Set this field to consider the server time (not localised)
  4. Set this field as a prompted (runtime) filter and select a value e.g. 11/17/2017 1:57:28 AM
  5. Run the report and check that the prompted filter value selected is the same as when creating the report i.e. 11/17/2017 1:57:28 AM
  6. Now share the report with two users from different locations e.g. United States and India
  7. If the user from the USA runs the report, the filter value selected will be localised to 11/16/2017 7:57:28 PM


  8. If the user from India runs the report, the filter will be localised to 11/17/2017 9:57:28 AM


  9. As the field was set to consider the server time, no matter who runs the report, the result will be 11/17/2017 1:57:28 AM
    not localised.png


This is an expected behavior.


When the user runs the report and selects the prompted filter, the values available will be localised, regardless of whether the field is set to be localised or not.
(Edit Report > Configurtion Pill > 'Localized' check box)
As the filter values come from the module, they will consider the timezone of the logged in user.

Hence the result of the report (regardless of who runs it) will consider what you have configured in the field (localised or server time).

The option to change the configuration to 'localized' or 'not localized' is only available for Table Reports (AdHoc), tiles and dashboards don't have it. The values fetched in the tile/dashboards are not localized. Therefore, it is possible to have one value in the filter (localized) and another one in the tile/dashboard(not localized).

See Also

2343660 - Adhoc Report date difference by 1 day


Timestamp, date,  filter,  values, not,  localize, localise, report, timezone, server, locale, logged in, mismatch, not, working , KBA , LOD-SF-ANA-ORD , Online Report Designer , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , How To


SAP SuccessFactors HXM Suite all versions