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.
SAP Knowledge Base Article - Preview