Wednesday 4 September 2013

OBIEE 11g: Conditional Formatting on a Column based on other column is not working in OBIEE11g


This issue is with 11.1.1.5.0 and later versions including the latest version 11.1.1.7.1

Scenario:

In OBIEE 11g, conditional formatting on a column based on another column does not work as it did in OBIEE 10g. For example, in an analysis, you set the conditional format of a column to turn background color to red, based on the value of another column. This works in OBIEE 10g, but not in OBIEE 11g.

Solution:
  1. For the column for which you want to apply the conditional format , open the Column properties dialogue box. 
  2. Click on the Column Format tab.
  3. Set the value suppression to "Repeat" then the conditional format will work as per your requirement.