How To Compound / Cascade Boolean Logic AND And OR In BI Prompts
Last updated on JULY 10, 2016
Applies to:Oracle Fusion Sales Cloud Service - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
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.
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