SAP Knowledge Base Article - Preview

1608494 - How do you resolve Web Intelligence 4.0 Query Panel incorrectly altering constant datetime filter values?


  • Web Intelligence 4.0 document reporting off a UNX Universe created in the Web Intelligence Java Report Panel.
  • Query Filter specifies a DateTime Constant filter value.
  • When the SQL statement is constructed, the Constant DateTime value is incorrectly scaled from local TimeZone to GMT.
  • For example, when '07/06/2011 12:00:00AM' is entered, the SQL statement filters on value '07/06/2011 08:00:00AM'



SAP BusinessObjects Business Intelligence platform 4.0


KBA , 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.