My Oracle Support Banner

OBIEE 12c: Custom Heading May Not Be Used For Conditional Format Column (Doc ID 2263628.1)

Last updated on FEBRUARY 28, 2019

Applies to:

Business Intelligence Suite Enterprise Edition - Version and later
Information in this document applies to any platform.


If you create a long case statement in Column Formula and set Custom Headings, then create a Conditional Format based on that case statement.
You will find that the part of the SQL statement may include the column name, and not the custom heading.

The behavior can be reproduced with the following steps:

  1. Create an analysis by adding columns from Analysis > 'Criteria' tab
  2. Add a formula to the column in analysis by selecting the 'Edit Formula', check the 'Custom Headings' checkbox and enter your custom name in the 'Column Heading' fields.
  3. Click OK button to save and then Select 'Column Properties' > 'Column Format' tab. Custom Column Heading is shown for the column as expected.
  4. Now click on 'Conditional Format' tab > 'Add Condition' button. Note that the custom column heading is there as well. Select the column and open the 'New Condition' dialog.
  5. The custom Column Heading name is no longer there. Instead the formula entered in step (b) is seen.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.