RSS

Setting default Graph series colors in OBIEE 11g

17 Apr

In OBIEE 10g to configure default Graph series colors we used to configure the \OracleBI\web\app\res\s_{StyleName}\chartsupport\palette.cxml file. The same we can configure in our OBIEE 11g Application by adding the series of Items colors in <MW_HOME>\Oracle_BI1\bifoundation\web\msgdb\s_blafp\viewui\chart\dvt-graph-skin.xml after </SliceLabel> as shown below:

<Graph>

<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=”#00ff00″ borderColor=”#00ff00″/>

<Series id=”2″ color=”#0000ff” borderColor=”#0000ff”/>

</SeriesItems>

</Graph>

You need to add the extra series values depends on no.of series or default colors you want to configure.

 

Thanks,

Shiva

Advertisements
 
12 Comments

Posted by on April 17, 2011 in OBI EE, OBIEE 11g

 

12 responses to “Setting default Graph series colors in OBIEE 11g

  1. Larissa

    May 11, 2011 at 12:48 pm

    Thanks

     
  2. Jitendra

    July 15, 2011 at 12:48 pm

    Good work Shiva!

    It will save lot of hassel for developer 🙂

    Thank you!

     
  3. Jitendra

    July 21, 2011 at 12:18 pm

    Shiva,

    I tried to implement this, even after restart, the changes are not taking place.

    Can you suggest any troubleshooting steps

    Jitendra

     
  4. Jitendra

    July 21, 2011 at 2:35 pm

    Good Work!!!

    After restart, it’s working absolutely fine…It’s my mistake of not checking it throughly before raising flag.

     
  5. Nir

    August 10, 2011 at 6:41 am

    Thanks for the post.
    Are there any other options of setting this file?

    I want, for example, to define the line format and the symbol type as default for all series items.

     
  6. Ritesh

    September 13, 2011 at 6:45 am

    Hi,
    I tried the above procedure but getting the following error
    Graphing engine is not responding.

    A fatal error occurred while processing the request. The server responded with: oracle.bi.nanserver.fwk.exception.BISvsException: oracle.dss.util.xml.BIParseException: Attribute value should start with quote..Any idea as to where i might be going wrong.I am using 11.1.1.5

    Thanks

     
  7. Vlad

    October 18, 2011 at 4:52 pm

    Ritesh, after you copied the highlighted text from Shiva’s article, make sure all double quotes are placed properly, and remove one extra space after the pound sign in the line defining the color 0. It works like a charm after that. I was able to migrate default palette for a customer after upgrading them from 10g to 11g.

     
  8. sreekanth

    November 10, 2011 at 8:46 pm

    Hi Shiva,

    Thanks for your posting. We are having issues on stacked charts, colors are stacking from bottom instead of stacking on top.

    Example: id=0 color should be on bottom and id=1 color should be on top of id=0 and so on…. Instead its working in reverse direction.

    Can you guys help me.

     
  9. LuisCunha

    August 17, 2012 at 3:48 pm

    Do you have a solution for this issue sreekanth?

    Thanks

     
  10. Deepak

    April 19, 2013 at 11:32 pm

    Hi Shiva,

    I tried to change graph color the way you mentioned, It’s working fine till 11.1.1.6.8 but it’s not working in 11.1.1.7.0. Any idea? Do we need make chnages some where else in 11.1.1.7.0.

    Thanks

     
  11. houshmand rastin

    July 1, 2013 at 10:02 am

    hi ,

    please how what-if analysis in obiee 11.1.1.7.0?

    thanks

     
  12. Chris

    September 7, 2013 at 9:40 pm

    This works great! Now how can I change the colors available to BI Answers users when they open chart properties and change the colors using the”Color Selector”? I need to change the colors in the color selector… Are these also in a msgdb file?

     

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: