cancel
Showing results for 
Search instead for 
Did you mean: 

Query Filter does not have OR operator in BICS

Former Member
0 Kudos

Hi,

I have a Web Intelligence Document created using BICS connection.

When I go to Query Filter pane and create filters using more than single dimension I get an AND operator by default.

While the requirement in some cases is also to have the ability to include an OR operator for certain filter criteria.

I have come across SAP Note 1687933 and it suggests that this is as "By Design".

What is the suitable workaround to achieve the OR operator functionality using BICS ?


Regards,

Amogh

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

That's a limitation of BICS , for work around you may have to put filter a "report level" in the design which allow you "OR" condition instead of "query filter"

Answers (1)

Answers (1)

tanveer1
Active Contributor
0 Kudos

If you click or double click AND button it should toggle between AND and OR

Former Member
0 Kudos

Tanveer,

For your info, that has been tried out for Query Filter. It does not work for for BICS model. This is a future enhancement if ever brought out in the product.

Instead with the Report filter this is possible.

-Amogh