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

Last updated on MAY 18, 2017

Applies to:

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

Symptoms

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.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms