1928536 - Native filter does not support optional prompt, althouth it is possible to define native filter with optional prompt in Information Design Tool | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

1928536 - Native filter does not support optional prompt, althouth it is possible to define native filter with optional prompt in Information Design Tool

Symptom

  • Native filter does not support optional prompt, althouth it is possible to define native filter with optional prompt in Information Design Tool (IDT)
  • Error occurs when running query with this native filter 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 with this native filter.
    =>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
  • 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 ; SAP BusinessObjects Business Intelligence platform 4.1

Keywords

BI4, BI4.0, 4.0, IDT, support, filter, native, optional, prompt, expression, IES, WIS, 10901, missing operator, missing expression, Database error, Error executing query, ADAPT01699435, 01699435, 1699435 , KBA , 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.