Oracle Transactional Business Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Embedding filters without converting to SQL

Received Response
91
Views
3
Comments

Summary:

Hello- Is there a way to embed a AND/OR statement into a filter without converting to SQL?

Content (required):

We are in need of a workaround that does not require us to convert a filtering condition into SQL. The filter needs to be and AND/ OR statement.

Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):

Tagged:

Answers

  • Nathan CCC
    Nathan CCC Rank 7 - Analytics Coach

    Yes. Select the AND to toggle to OR.


  • Venkat Koduvayur-Oracle
    Venkat Koduvayur-Oracle Rank 4 - Community Specialist

    Hi

    Yes, it is possible. With out converting to sql means you mean selecting the option "Convert this filter to SQL"?

    Yes by clicking the AND condition will change the filter to OR and we can keep adding nested OR filters as shown


    Regards

    Venkat

  • Anirban Basu-133546
    Anirban Basu-133546 Rank 5 - Community Champion

    Yes in the filters pane you can change the operators as per your requirements.