Symptom
- 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
Read more...
Environment
- BusinessObjects Enterprise XIR2
- BusinessObjects Enterprise XIR3.1
- Universe Designer XIR2
- Universe Designer XIR3.1
Product
SAP BusinessObjects Enterprise XI
Keywords
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.