1687933 - BI 4.x - In the Query Panel of Web Intelligence or Crystal Reports for Enterprise - It is not possible to use "OR" operator when creating Query Filters on BEX Query | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

1687933 - BI 4.x - In the Query Panel of Web Intelligence or Crystal Reports for Enterprise - It is not possible to use "OR" operator when creating Query Filters on BEX Query

Symptom

  • BI 4.x - Web Intelligence Query Panel - not possible to use "OR" operator when creating a query filters on BEX Query using BICS connection.
  • When creating a report off a BEx Query in Crystal Reports for Enterprise, and adding multiple filters in the Query Panel, it always uses the AND operator, and it is not possible to change it to the OR operator.

Read more...

Environment

  • SAP BI 4.0
  • SAP BI 4.1
  • SAP BI 4.2    
  • WebIntelligence - Query Panel
  • BW 7.x & BEx Query Designer
  • Also including OLAP vendors: Microsoft Analysis Services 2008, Oracle Hyperion Essbase v11
         
  • SAP Crystal Reports for Enterprise 4.0
  • SAP Crystal Reports for Enterprise 4.1
  • SAP Crystal Reports for Enterprise 4.2

 

Product

SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.1

Keywords

webi web intelligence 4.0 4.1 query panel filter AND OR operator bics BEx query data source by design , KBA , BI-RA-WBI , Web Intelligence , BI-RA-BICS , BI consumer services , BI-RA-MD , OLAP Intelligence, multidimensional databases , Product Enhancement

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.