SAP Knowledge Base Article - Preview

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

Symptom

  • 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)

Read more...

Environment

  • 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)

Product

SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.0, feature pack 3

Keywords

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

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.