SAP Knowledge Base Article - Preview

2272282 - Derived Table With @Prompt Error In IDT


  • After creating a table in IDT within the data foundation using @Prompt parameter the validation fails.
  • Derived table was created out of a HANA View.
  • The parameter is defined the view as a string.
  • Error message in IDT when validating:
    Invalid expression.
    SAP DBTech JDBC: [257] (at z): sql syntax error: incorrect syntax near "...": line x col y (at pos z) *


*Where "x" indicates the line and "y" states the column/position of the error in the SQL. The number "z" tells the position of the error counted from beginning of the SQL script.



  • SAP BusinessObjects Information Design Tool 4.x
  • SAP Hana DB


SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.1 ; SAP BusinessObjects Business Intelligence platform 4.2


unx, idt, dfx, parameter, input control, input, error, webi, hana, handb, bip, derived, prompt,  , 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.