1830927 - BI 4.0 IDT: Where Clause Is Empty

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.

SAP BusinessObjects Business Intelligence 4.0 Service Pack 5

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