SAP Knowledge Base Article - Public

3101935 - New Columns Added for Reporting for Time Zone Resilient Date Fields - Table Report/Canvas/Tiles/Report Story

Symptom

A new version of some date fields (columns) for Table, Tile, Canvas, and Story reports is available, suffixed with either (Timestamp) or (Date).

From the 2111 delivery, there will be a change for non-UTC customers in case any timezone conversion is carried out. Instead of assuming the server time to be in UTC, a non-UTC server time is honored. Therefore customers potentially notice a change in the date time display that changes from an incorrect to a correct conversion. The platform time will be change to UTC 30 days prior to your transition to the hyperscaler environment as part of the Next Generation Cloud Delivery program. Please visit the SAP Next-Generation Cloud Delivery Dashboard, available on SAP for Me, for additional information, including your specific transition dates.

To identify these fields there will be the suffix in the new fields that indicates that the fields are resilient to time zone changes. The fields suffixed with (Timestamp) display a transaction date as per the tenant preferred timezone (or as per the logged in user's timezone), whereas the fields suffixed with (Date) are independent of time zone and always display the same values. To know more about tenant preferred time zone, refer to the Tenant Preferred Time Zone Available in Admin Center topic. To see the list of new fields, refer to the articles listed in the resolution section.

"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

Resolution

With the 2H 2021 release we are introducing the Tenant Preferred Time Zone field to mitigate the impact of the UTC migration.

Changes in the different reporting models (i.e.meta data changes) are done to meet the expected behavior of time zone changes and ensure UTC resilience. Typically these model changes are made available to customers as new columns which are copies of existing columns and containing the metadata change.

We highly recommend that you replace the older date columns in your Table, Tile, Canvas, and Story reports with their newer version, which are time zone resilient. Additionally, you must use only the newer version of the date fields in all your future reports.

If your required actions are not carried out before the platform time is changed to UTC 30 days prior to your transition to the hyperscaler environment, then you may incur potential issues. Reports which included fields in local time could start bringing time in UTC instead.

See below how the fields will appear for selection:

Example on how the fields will appear on Report Table:


Example on how the field will appear on Report Story:


Please see below example of change on the extract of data on table reports:

Local Server time/TPT: CHN (UTC +8 hours)
User Preferred Timezone CHN (UTC +8 hours)

Old Column
Application Date

New Column:
Application Date (Timestamp)

Before MigrationApplication Date 22.06.2020Application Date 22.06.2020 07:02:38
After Migration (-8 hours)Application Date 21.06.2020
(change in reporting)
Application Date 22.06.2020 07:02:38
(no change in reporting)

Please see below example of change on the extract of data on Story reports:

Local Server time/TPT: CHN (UTC +8 hours)

Client Timezone CHN (UTC +8 hours)

Old Column

Application Date

New Column

Application Date (Timestamp)

Before MigrationApplication Date 22.06.2020Application Date 22.06.2020 07:02:38
After Migration (-8 hours)Application Date 21.06.2020
(change in reporting)
Application Date 22.06.2020 07:02:38
(no change in reporting)

The date fields that will change are mentioned on the KBAs below which will be available up to the release date:

KBA 3106280 for fields on Story
KBA 3106255 for fields on Table/Canvas/Tile and Dashboards


Keywords

(Timestamp), (Date), field, change, timezone , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , Product Enhancement

Product

SAP SuccessFactors HXM Suite all versions