SAP Knowledge Base Article - Preview

1219305 - OpenSQL driver misreads negatives in selection formula in Enterprise for SAP


An empty result set is generated when using selections such as the following:

({PA0002.GBPAS} <= Date(0,0,0) or {PA0002.GBPAS} > CurrentDate)


The problem occurs because the information is passed to the driver as the following (in pseudo code):

!({PA0002.GBPAS} > Date(0,0,0) and {PA0002.GBPAS} <= CurrentDate).


The OpenSQL driver misses the initial and all-encompassing negation.


In the example above, instead of discarding the middle interval, it discards everything outside the interval.



SAP BusinessObjects Business Intelligence platform R2 ; SAP BusinessObjects Enterprise XI


CE CHF 521291 OPENSQL OPEN SQL DRIVER SAP NULL RECORD RESULT SET BusinessObjects Enterprise SAP OpenSQL driver , c2018513 , KBA , BI-BIP , Business intelligence platform , 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.