3680877 - Different SQL timestamp format generated in UNV vs UNX universes when filtering Oracle data in Web Intelligence

• When converting a UNV universe to UNX, the generated SQL syntax for date parameters changes.
• This behavior is observed when:
  • A first Web Intelligence query retrieves start and end dates (in Date format).  
  • These values are then passed as parameters to a second query based on another universe.  
  • In the second query, the UNX version, the generated SQL no longer includes the TIMESTAMP keyword.
    • UNV (Expected behavior): "date" >= TIMESTAMP '2025-08-01 00:00:00'
    • UNX : "date" >= '01-08-2025 00:00:00'

• SAP BusinessObjects Business Intelligence Platform 2025
• SAP BusinessObjects Business Intelligence Platform 4.x
• Web Intelligence
• Information Design Tool
• Oracle database

UNX, UNV, universe conversion, Web Intelligence, Oracle, PRM, USER_INPUT_DATE_FORMAT, TIMESTAMP, Data Federation Engine, IDT, BLX, DFX , KBA , BI-BIP-IDT-BLX , Business Layer , Problem