SAP Knowledge Base Article - Preview

1935659 - Incorrect SQL generated when using the "Calculation" operand in a condition in the query panel

Symptom

  • Getting the following error while running a DeskI report using "calculation" operand in a condition in the query panel- "Exception:DBD, [Microsoft][<Driver>]Syntax error in query expression'<Expression>'. State: 42000".
  • Error appears in a situation when one object is coming from the main table and the other coming from its alias table.


Read more...

Environment

  • BusinessObjects XI 3.1 SP5 Fixpack 5.1 (and higher fixpacks)
  • BusinessObjects XI 3.1 SP6
  • Desktop Intelligence

Product

SAP BusinessObjects Enterprise XI 3.1

Keywords

calculation, sub query, alias, DeskI, incorrect SQL , KBA , BI-RA-DKI , Obsolete - Desktop Intelligence , Bug Filed

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.