Tuesday, December 10, 2013

Changing Default Graph Colors in OBIEE 11g

 

In OBIEE 10g the default Graph colors could be changed by configuring the pallete.cxml located at \OracleBI\web\app\res\s_blaf\chartsupport\palette.cxml file. In OBIEE 11g this can be configured by adding the series colors in<MW>\Oracle_BI1\bifoundation\web\msgdb\s_blafp\viewui\chart\dvt-graph-skin.xml or <MW>/Oracle_BI1/bifoundation/web/msgdb/s_FusionFX/viewui/chart/dvt-graph-skin.xml (in newer versions).  Add lines after </SliceLabel> to specify the colors. Also make sure to take a back-up of the original file.

<SliceLabel>

   <!– decimalDigitUsed is false here so that non-percentage pie slices do not pick up this value

        The DVTChartProcessor sets decimalDigitUsed to true if this is a percentage pie slice –>

   <ViewFormat decimalDigit=”2″ decimalDigitUsed=”false”/>

</SliceLabel>

<SeriesItems>
<Series id="0" color="#ff0000" borderColor="#ff0000"/>
<Series id="1" color="#ff8e45" borderColor="#ff8e45"/>
<Series id="2" color="#aaa4dc" borderColor="#aaa4dc"/>
<Series id="3" color="#ff66ff" borderColor="#ff66ff"/>
<Series id="4" color="#00ff00" borderColor="#00ff00"/>
<Series id="5" color="#9de3f9" borderColor="#9de3f9"/>
<Series id="6" color="#dbacf3" borderColor="#dbacf3"/>
<Series id="7" color="#0000ff" borderColor="#0000ff"/>
<Series id="8" color="#886ecc" borderColor="#886ecc"/>
<Series id="9" color="#fac969" borderColor="#fac969"/>
<Series id="10" color="#ffccf5" borderColor="#ffccf5"/>
</SeriesItems>

</Graph>

After clearing cache, these changes are effective immediately and there is no need to restart OBIEE services.