SAP Knowledge Base Article - Preview

3608612 - Date displayed incorrectly in WebI report with Snowflake database

Symptom

  • After upgrading to BI 4.3 SP4 Patch 11 or higher, date/time values ​​are displayed incorrectly in CAST functions, they displayed correctly in the previous version.
  • The dates are displayed with a one-day offset or a discrepancy regarding the selected time zone.


Read more...

Environment

  • SAP BusinessObjects Business Intelligence Platform 4.3 Support Package 4 Patch 11
  • Web Intelligence (WebI)
  • Snowflake

Product

SAP BusinessObjects Business Intelligence platform 4.3

Keywords

BI 4.3 SP4 Patch 11, BI 4.3 SP4 Patch 12, BI 2025 Patch 10, SAP BusinessObjects Business Intelligence platform, Web Intelligence, WebI, BI Launchpad, Snowflake, JDBC, snowflake.sbo, TIMESTAMP_NTZ, DATETIME, TIMESTAMP_TZ, CAST, SQL, Free Hand SQL, universe, Use UTC, UTC, time zone, timezone, offset, GMT, time, date, dates/times, incorrect, shifted, -1 day, Current Time Zone, True, False, parameter, prm, sbo, design change, upgrade, query panel, report, BI 4.3, SIA, Server Intelligence Agent, CCM, Central Configuration Manager, restart, dataAccess, jdbc , KBA , BI-BIP-SL , Semantic Layer , BI-RA-WBI , Web Intelligence , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.