3101935 - Coordinated Universal Time (UTC) for SuccessFactors Story Reports

SAP SuccessFactors is standardizing the use of time across all our systems (applications, databases, and servers) across all our data centers in our continuous effort to align with the cloud industry's best practices for improved data integrity, security and scalability. SAP SuccessFactors has moved its platform to Coordinated Universal Time (UTC).

SAP SuccessFactors offers global services and currently supports multiple time zones. We must have a consistent, reliable time zone across all geographies to ensure that applications behave the same regardless of physical location. UTC is a natural choice given our global customer base, and UTC is not subject to Daylight Saving Time.

The impact is that a new version of some date fields (columns) for Table, Tile, Canvas, and Story reports are available, suffixed with either (Timestamp) or (Date). The fields suffixed with (Timestamp) display a transaction date as per the logged-in user's time zone, whereas the fields suffixed with (Date) are independent of time zone and always display the same values.

IMPORTANT

• 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.

"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 HCM Suite

Planning for this change, we introduced 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. 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:

Below are example time conversions in Table report after UTC migration:

Application Date *Not Localized* - UTC
Application Date (Timestamp) *Not Localized* - DC time zone
Application Date/Application Date (Timestamp) *Localized* - Time zone of a user maintained in UDF

For Story, Application Date/Application Date (Timestamp) are stored in DB as UTC. By default, they are being localized in Story, which converts the transaction date to logged in user's browser time zone.

Below is a table showing how different types of data are currently working in Story Report:

DB Type	SDS Type	Localized
Datetime	datetime	Yes
Date	date	No
Time	time	No

The date fields that will change are mentioned in the KBAs below:

• New Data Fields in Reporting supporting Tenant Preferred Time Zone in 2H 2021 Release
• SAP SuccessFactors is moving to Coordinated Universal Time (UTC)
• 3140223 - FAQ: SuccessFactors DataCenter time Zone as UTC
• 3108427 - List of Fields that Will Face UTC changes for Reports - Calibration
• 3107000 - List of Fields that Will Face UTC changes for Reports - Career Development Planning and Mentoring
• 3098700 - List of Fields that Will Face UTC changes for Reports - Compensation and Variable Pay
• 3106280 - List of Fields that Will Face UTC changes for Reports - Employee Central
• 3107940 - List of Fields that Will Face UTC changes for Reports - Goal Management
• 3106935 - List of Fields that Will Face UTC changes for Reports - Succession Planning
• 3108709 - New date fields for Onboarding Schema in Analytics Tools - Onboarding 1.0
• 3047665 - Recruiting Management Adhoc and Story reports New columns added (Timestamp) and SFAPIs New Fields for Date type fields
• 3362155 - SAP SuccessFactors Is Moving To Coordinated Universal Time (UTC) - Employee Central
• 3362362 - UTC Migration impact on Compensation - SAP SuccessFactors
• 3362023 - UTC Migration impact on Learning Management System (LMS) - SAP SuccessFactors
• 3362299 - UTC Migration impact on Performance Management (PM) & 360-MTR - SAP SuccessFactors
• 3360608 - UTC Migration impact on Platform and Metadata Framework (MDF) - SAP SuccessFactors
• 3353113 - What is the impact on WFA after moving to Coordinated Universal Time (UTC)? - WFA on Hana and SQL

(Timestamp), (Date), timezone, utc, Coordinated Universal Time, new, story reports, table, canvas, dashboard, tiles, wfa, workforce analytics, Tenant Preferred Time Zone, localized , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , LOD-SF-WFA-REP , Reports, Data, Insight , LOD-SF-EC-REP , Reporting Data (EC core only) , LOD-SF-RCM-REP , Reporting & Analytics, Data Imports & Exports , LOD-SF-ANA-SAC-DAM , Data Modelling - Module & Entity Data Issues , LOD-SF-ANA-DSH , YouCalc Dashboards and Tiles (Dashboards 2.0) , LOD-SF-OBD-REP , Reporting & Analytics, Data Imports & Exports , LOD-SF-SCM-REP , Reporting and Data Imports Exports , LOD-SF-GM-REP , Reporting and Data Imports Exports , LOD-SF-CMP-REP , Reporting & Analytics, Data Imports & Exports , LOD-SF-VRP-REP , Reporting & Analytics, Data Imports & Exports , LOD-SF-MEN-REP , Reporting & Analytics, Data Imports & Exports , LOD-SF-CDP-REP , Analytics & Reporting , LOD-SF-INT-API , API & Adhoc API Framework , LOD-SF-ANA-RCT-SAC , People Analytics Stories , LOD-SF-ANA-RCT-YCL , YouCalc Tile & Dashboard , LOD-SF-ANA-RCT-CAN , Report - Canvas , How To

SAP SuccessFactors Compensation all versions ; SAP SuccessFactors Employee Central all versions ; SAP SuccessFactors Learning all versions ; SAP SuccessFactors Onboarding all versions ; SAP SuccessFactors Performance & Goals all versions ; SAP SuccessFactors Recruiting all versions ; SAP SuccessFactors Succession & Development all versions ; SAP SuccessFactors Workforce Analytics all versions