OBIEE 11g Default Color Selection For Stacked Bar Is Different (exactly Opposite Order) Than Other Graph Types (Doc ID 1904045.1)

Last updated on JANUARY 30, 2017

Applies to:

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

Symptoms

Colors in Stacked Bar Charts are in the same order as in other chart types, however the dimension values order is reversed. So, the values are assigned different colors for Stacked Bar Charts, compared with other chart types.

Steps to reproduce:

  1. Criteria tab:
    Create analysis containing:
    • Products (filtered to first 7 values)
    • Offices (fintered to first 7 values)
    • Revenue
  2. Results tab:
    Create: Stacked Vertical Bar graph
    Legend values:
    • Dark Blue: Bluetooth Adaptor
    • Red: Micropod 60GB
    • Mauve: SoundX Nano 4Gb
    • Dark green: Keymax S-Phone
    • Orange: Touch-Screen T5
    • Dark pink: CompCell RX3
    • Light green: V5x Flip Phone
  3. Results tab:
    Create: Pie Graph
    Legend values:
    • Dark Blue: V5x Flip Phone
    • Red: CompCell RX3
    • Mauve: Touch-Screen T5
    • Dark green: Keymax S-Phone
    • Orange: SoundX Nano 4Gb
    • Dark pink: Micropod 60GB
    • Light green: Bluetooth Adaptor
  4. Results tab
    Create: Bar Graph
    Ensure that product is in the 'Vary Color By (Horizontal Axis)' section.
    Legend values:
    • Dark Blue: V5x Flip Phone
    • Red: CompCell RX3
    • Mauve: Touch-Screen T5
    • Dark green: Keymax S-Phone
    • Orange: SoundX Nano 4Gb
    • Dark pink: Micropod 60GB
    • Light green: Bluetooth Adaptor

So, the colours are in the same order in all three charts, however, the order of the values has been reversed in the Stacked Vertical Bar graph.

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