Symptom
Handwritten SQL that performed correctly prior to BI 4.2 SP 8 throws an "Invalid expression" error in SP 8. For example:
SELECT MyTable.MyColumn MT1 IN (SELECT MT1.OtherColumn WHERE MT1.OtherColumn='X')
Read more...
Environment
- SAP BusinessObjects Business Intelligence 4.2 Support Pack 8
- Information Design Tool (IDT)
Product
SAP BusinessObjects Business Intelligence platform 4.2
Keywords
sql fhs freehand free hand written custom specific encoded encode decoded decode evaluate evaluated substituted executed , KBA , BI-BIP-IDT-CX , Connection Layer , 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.