SAP Knowledge Base Article - Preview

3085513 - Handwritten SQL No Longer Works

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.