SAP Knowledge Base Article - Preview

1262247 - Time Ignored In A Date & Time Filter


  • We have a universe filter object defined using a date & time field. The purpose of the filter is to prompt for From and To entries. The universe uses a predefined condition that is pointing to a date dimension object.The problem is that the time value entered in the Prompt field is not translated into the SQL. If datetime selected is 02/11/2008 00:00 to 02/11/2008 23:59 the SQL generated contains:WHERE  ( (Tablename.DateObjectName1) >= '02/11/2005 00:0:0' AND (Tablename.DateObjectName1) <= '02/11/2005 00:0:0' )
  • Note that the time is always 00:0:0
  • Sql Swerver using timestamp in a prompt



  • BusinessObjects Enterprise XIR2
  • BusinessObjects Enterprise XIR3.1
  • Universe Designer XIR2
  • Universe Designer XIR3.1


SAP BusinessObjects Enterprise XI


timestamp time predefined condition datetime , KBA , BI-BIP-SL , Semantic Layer , 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.