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:
- For the column for which you want to apply the conditional format , open the Column properties dialogue box.
- Click on the Column Format tab.
- Set the value suppression to "Repeat" then the conditional format will work as per your requirement.