RSS

Showing both X-axis and Y-axis values in Scatter chart Tooltip

11 Feb

Normally in a scatter chart when we are showing the tooltip, we are seeing only Y-Axis values but making some alternations we can include both the x-axis and y-axis values in the tooltip.

 For this you need to alter scatter.pcxml file.
you have to update this file in two locations.
1.\OracleBI\web\app\res\s_<stylename>\popbin
2.\OracleBI\oc4j_bi\j2ee\home\applications\analytics\analytics\res\s_<stylename>\popbin

 in this scatter.pcxml file
in between <Graph> tag search for Datalabels tag,here you have to identify formatstring value like this:

 <DataLabels Font=’Size:9;Style:Bold;’ TransparentBackground=’False’ BGColor=’#FFFFFFcd’ FormatString=’%_XVALUE&#xA;%_YVALUE’ />

It will give you both X and Y values at your Tooltip. Where &#xA; is for new line character in xml.

I tried this example using paint.rpd’s Region, Brand and dollars and this is screen shot for X and Y values at tool tip.

  scatterxytooltip

Advertisements
 
2 Comments

Posted by on February 11, 2009 in OBI EE

 

2 responses to “Showing both X-axis and Y-axis values in Scatter chart Tooltip

  1. Madan

    February 12, 2009 at 4:51 pm

    Good One, But instead of showing 1,1 in tool tip, if you show region and brand values that will be great.

     
  2. psuelement

    February 23, 2011 at 5:33 pm

    Hi Shiva,

    Do you know if it’s possible to show in the tool tip the x and y axis for the bar or the line charts?

    Thank you

     

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: