SAP Knowledge Base Article - Preview

1635925 - The Web Intelligence report query panel is not allowing to keep the Universe objects of one class in the sub-query filter first text box even though the object has the right to create "Condition" and "Sort" but not "Result".It throws "You cannot use the object in the filter pane"

Symptom

  • The Web Intelligence report query panel is not allowing to keep the Universe objects of one class in the sub-query filter first text box even though the object has the right to create "Condition" and "Sort" but not "Result"
  • The SQL includes the object name selected in the Sub-query’s Left object box in the WHERE Clause and that object has right to create "Condition" and "Sort" but not to use in "Result" set at Universe Object >> Advanced Properties
  • It gives the tooltip "You cannot use the object in the filter pane".

 


Read more...

Environment

  • Business Objects Version: XIR3.1 SP3 FP3.6
  • Server Operating System: Windows Server 2008
  • CMS Database: Oracle 11G
  • Reporting Database: Oracle 10G
  • Database Middleware: Oracle native client drivers
  • JDK Version: Java 1.6.0_23
  • Java or .NET: Java
  • Authentication type: LDAP, Enterprise

Product

SAP BusinessObjects Business Intelligence platform R2

Keywords

subquery, sub query, restriction, web intelligence report, webi report , KBA , BI-RA-WBI , Web Intelligence , Bug Filed

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.