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.