OBIEE11g/ 12c: Total Column Formatting may not Work When Using Table Sections

(Doc ID 2273957.1)

Last updated on JUNE 09, 2017

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.7.170418 to 12.2.1.2.170418 [Release 11g to 12g]
Information in this document applies to any platform.

Symptoms

When you create an Analysis in Presentation and you try to set the cell style of the footer-total (Grand Total) in a Table View,

the Format Values is not retained when moving column to section.


Steps to reproduce:

  1. Create a new analysis for example.
    Offices/Office
    Products/Product Type
    Base Facts/Billes Quantity
    Base Facts/Revenue
  2. Move to the "Results" tab.
  3. Move the Office column to section.
  4. Edit the Table View in order to add the "Grand total" After.
  5. Edit the 'Format Labels' to change the background color to YELLOW for example.
  6. Edit the 'Format Values' to change the background color to RED for example.

The background color of Values cell does not change. Only the Labels has the background changed to YELLOW.

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