SAP Knowledge Base Article - Preview

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

Symptom

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.


Read more...

Product

SAP BusinessObjects Business Intelligence platform R2 ; SAP BusinessObjects Enterprise XI

Keywords

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.