SAP Knowledge Base Article - Public

3513192 - Time Zone Difference Between Story Designer and Preview

Symptom

Date fields not working as expected potentially after potentially due to the SAC Q3 QRC, which happened on July 27th.
When previewing the query, date fields shows user's local time zone. However, when we use these fields in a Story designer, then they show UTC time zone.

Environment

  • SAP Analytics Cloud
  • SAP SuccessFactors

Reproducing the Issue

  1. Login to the instance
  2. Navigate to Reporting
  3. Create a new Story report and add any date field as well as their counterpart timestamp field.
  4. Preview results and note that the time is same for both fields. Also remember the results that we get
  5. Now finish the query, add both of the fields to a table widget and notice the time. It is also the same for both fields
  6. When you compare the difference between preview and in the table widget, you will notice that the preview follows user's locale and table widget shows UTC for both fields.

Cause

This issue is currently under investigation by our Development Team.

Resolution

This issue is currently under investigation by our Development Team.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Analytics Cloud, SAC, sapanalyticscloud, kba, note, help, knowledge, story, tenant, version, qrc, date, time, utc, timezone, time zone, preview, wrong, hours , KBA , LOD-ANA-OEM , Embedded usage of SAP Analytics Cloud , LOD-SF-ANA-SAC , Stories in People Analytics , Known Error

Product

SAP Analytics Cloud all versions ; SAP SuccessFactors HCM Core all versions