How To Compound / Cascade Boolean Logic AND And OR In BI Prompts (Doc ID 2147792.1)

Last updated on JULY 10, 2016

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.1.10.0.0 and later
Information in this document applies to any platform.

Goal

You have 2 prompts that are built for different columns. The user input types of these columns are one of Check Box, Choice List, List Box, or Radio Buttons.

You already know how to set up a prompt on this column, but you would like the end result (effectively a filter) to behave like this:

    (condition-a AND condition-b) OR condition-c


You have done the following already:
1. In the analysis Prompt tab, create two prompts for the desired columns with the relevant conditional operators selected.
2. On the analysis Criteria, Filter the desired date column using the "is prompted" operator.
3. Save the analysis.

However, since you have two prompts on different columns, you need to compound the boolean AND/OR logic to meet this requirement.

How to do this? Read below to find out.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms