1928527 - Derived table does not support optional prompt, althouth it is possible to define Derived table with optional prompt in Information Design Tool (IDT)

• Derived table does not support optional prompt, althouth it is possible to define Derived table with optional prompt in Information Design Tool (IDT)
• Error occurs when running query with any object from this derived table in IDT
  =>Error message : "Error executing query. Failed to execute runnable (java.lang.NullPointerException)"
• Error occurs when running a Web Intelligence document off this universe any object from this derived table
  =>Error message if database is access:
      Database error: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '<filter expression>'.。（IES 10901） (WIS 10901)
  =>Error message if database is Oracle:
      Database error: ORA-00936: missing expression. (IES 10901) (WIS 10901)

• SAP BusinessObjects Business Intelligence Platform 4.0 (BI 4.0) Support Pack 6
• SAP BusinessObjects Business Intelligence Platform 4.0 (BI 4.0) Support Pack 7
• Information Design Tool (IDT)
• Web Intelligence (WebI)

BI4, BI4.0, 4.0, IDT, support, derived table, optional, prompt, expression, IES, WIS, 10901, missing operator, missing expression, Database error, Error executing query, ADAPT01699435, 01699435, 1699435 , KBA , @prompt , optional prompt , BI-BIP-IDT , Information design tool , BI-BIP-SL , Semantic Layer , Bug Filed