Pages

Wednesday, February 20, 2013

Modifying the Colors Available in a Chart

In OBIEE 10g it was possible to set the color attributes for a chart by modifying palette.cxml file.How can you do this in OBIEE 11g?

Edit following file
<Oracle_BI1>\bifoundation\web\msgdb\s_blafp\viewui\chart\dvt-graph-skin.xml
Add lines after </SliceLabel> to specify the colours.  Here is an example giving a range of colours:


<SeriesItems>
<Series id="0" color="#4a9cd9" borderColor="#4a9cd9"/>
<Series id="1" color="#f68e55" borderColor="#f68e55"/>
<Series id="2" color="#a4aadc" borderColor="#a4aadc"/>
<Series id="3" color="#ffff66" borderColor="#ffff66"/>
<Series id="4" color="#99cc66" borderColor="#99cc66"/>
<Series id="5" color="#9de3f9" borderColor="#9de3f9"/>
<Series id="6" color="#dbacf3" borderColor="#dbacf3"/>
<Series id="7" color="#cc6699" borderColor="#cc6699"/>
<Series id="8" color="#886ecc" borderColor="#886ecc"/>
<Series id="9" color="#fac969" borderColor="#fac969"/>
<Series id="10" color="#1cc1f5" borderColor="#1cc1f5"/>
<Series id="11" color="#ccff99" borderColor="#ccff99"/>
</SeriesItems>


Refer the below link for Hex code.

http://hareeobiee.blogspot.in/2012/12/html-color-hex-codes.html
 
 


This way you can modify the colors for chart. Try it out.

3 comments:

  1. This works great! Now how can I change the colors available to BI Answers users when they open the "Color Selector" to choose colors? I need to change them to our approved color scheme... Are these also in a msgdb file?

    ReplyDelete
  2. Hello,
    thanks for your post.
    I want to do the same on the new version: 11.1.1.9.0. The thing is that I cannot find the file "dvt-graph-skin.xml".
    Any idea?
    regards.

    ReplyDelete
  3. how to do this in OBIEE 12c?

    ReplyDelete