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

unx, idt, dfx, parameter, input control, input, error, webi, hana, handb, bip, derived, prompt,  , KBA , BI-BIP-IDT , Information design tool , Problem