SAP Knowledge Base Article - Preview

1862920 - Unable To Generate Timestamp When Filter From Multi-Source Universe

Symptom

  • When creating a query filter on the datetime object in Multi-Source universe the SQL generated is not showing the time stamp, instead of time stamp its showing {d ‘2012-05-27’} for the datetime object which leads no results.  However, the same query filter on the datetime object in Single-source showing time stamp (’27-05-2012 16:30:26’) as expected in the view script.


Read more...

Environment

  • SAP BusinessObjects Business Intelligence platform 4.0 SP5 Patch 5
  • Information Designer Tool
  • Windows 2008
  • Oracle 11G
  • SQL Server

Product

SAP BusinessObjects Business Intelligence platform 4.0

Keywords

Timestamp, Multi-sources, Datetime , KBA , BI-BIP-SL , Semantic Layer , Bug Filed

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.