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
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.
SAP Knowledge Base Article - Preview