How to create a condition based column in Column selector in OTBI Report?

User_P6HYL · Aug 5, 2025 7:53AM

We are creating an OTBI report in which we want to use column selector .

Inside that column selector, we are trying to add the condition based column but we are unable to do that, even not able to write the formula/function inside that.

Is it possible to do that in column selector.

If so, could someone guide me through the steps or provide an example?

Thank you for your assistance!

Riyaz Ali-Oracle · Aug 13, 2025 4:10PM

Hi @User_P6HYL,

Try the below:

Create Condition-Based Columns First
Go to your OTBI analysis.
Add a column from the subject area.
Click the gear icon next to the column → Edit Formula.
Write your condition-based logic using SQL expressions like:
Save the column with a meaningful name.
sql
CASE WHEN "Employee"."Department" = 'Sales' THEN 'Sales Group'
WHEN "Employee"."Department" = 'HR' THEN 'HR Group'
ELSE 'Other'
END
Add Column Selector View:
In the Criteria tab, add all the columns you want to toggle between—including your newly created condition-based column.
Go to the Results tab.
Click New View → Column Selector.
In the Column Selector configuration, choose the columns you want users to switch between.
Use in Table or Graph View
Make sure the Column Selector is linked to a Table View or Graph View that uses the selected column dynamically.

You can check the below for more details:

Create a column and view selector in a Fusion OTBI report

Thanks,
Riyaz Ali

MFA for Oracle Community

Oracle Transactional Business Intelligence

Categories

How to create a condition based column in Column selector in OTBI Report?

Answers