2774579 - Time portion of Oracle Datetime filter is ignored in a WebI report based on a multisource universe

• When using a multi source universe, it can be seen that the time part is being ignored, just the date part can be seen when creating a query in the business layer in Information Design Tool. For example if the date time is 2004-01-29 10:55:25.0, then only 2004-01-29 is seen in the SQL.
• The date format can be changed and viewed in case of single source universe in the particular database driver's .prm file. For example, in case the datasource is Oracle with ODBC driver, in the following file can the date format changed, by changing the USER_INPUT_DATE_FORMAT parameter:
  <Installation directory>\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\odbc\extensions\qt\oracle.prm
• By default the user input date format is seen as following in case of Oracle for a Single Source Universe:
  <Parameter Name="USER_INPUT_DATE_FORMAT">'dd-MM-yyyy HH:mm:ss'</Parameter>

• SAP BusinessObjects Business Intelligence Platform 4.0
• SAP BusinessObjects Business Intelligence Platform 4.1
• SAP BusinessObjects Business Intelligence Platform 4.2
• Information Design Tool
• Multi source universe (MSU)
• Web Intelligence (WebI)
• Oracle OCI Connection
• ODBC connections
• JDBC connections

multi, source, Multi-source, date time universe, date, time, timestamp, how, to, idt, qt, bi, datafederator, prm, dateformat, user, input, Oracle timestamp, MSU , KBA , BI-BIP-SL , Semantic Layer , BI-BIP-IDT , Information design tool , BI-BIP-DF , Data Federation Service , Problem