Oracle Analytics and AI

User_P6HYL

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

Hi @User_P6HYL,

Try the below:

1. 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
2. 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.
3. 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