SAP Knowledge Base Article - Preview

1830927 - BI 4.0 IDT: Where Clause Is Empty

Symptom

The BI 4.0 SP5 Information Design Tool generates a Where clause that is just an open and closed parenthesis.

SELECT

  Field1, Field2

FROM

  Table1, "TBL_@PROMPT('Enter Table Number','A',{'Choice1','Choice2'},MONO,CONSTRAINED)" Table__2

WHERE

  ( )

Even if a filter is added, it will be added as an AND after the empty WHERE.


Read more...

Environment

SAP BusinessObjects Business Intelligence 4.0 Service Pack 5

Product

SAP BusinessObjects Business Intelligence platform 4.0

Keywords

bi 4.0 bi4.0 bi40 40 information design tool idt empty blank no where clause parenthesis parentheses prompt part type object table name substitute replace token , KBA , BI-BIP-IDT , Information design tool , Problem

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.