Wednesday, January 16, 2008

OBIEE X,Y and data in mouse over label

One of our custumers wants not only the data value in the mouse over label but als the X and Y axis value.

You can achieve this by editing the ".PCXML" for the graph type.




%_BUBBLE_VALUE=> The value for the bubble item. [bubble]
%_CATEGORY_NAME => The name of the category that the data item belongs to. [All, except, X-Y and Time Plot]
%_CATEGORY_TOTAL => The sum of all data values in the category to which the data item belongs. [Area, Bar, Line, Pareto, Pie, Radar]
%_CLOSE_VALUE => The close value for a high-low data item. [Stock]
%_GRAPH_TOTAL => The sum of all data values in a bar, line, pie, or radar graph. [Area, Bar, Line, Pareto, Pie, Radar]
%_HIGH_VALUE => The high value for a high-low data item. [Stock]
%_LOW_VALUE => The low value for a high-low data item. [Stock]
%_OPEN_VALUE => The open value for a high-low data item. [Stock]
%_PERCENT_OF_CATEGORY => The data value represented as a percentage of the sum of all data values in its category. [Area, Bar, Line, Pareto, Pie, Radar]
%_PERCENT_OF_TOTAL => The data value represented as a percentage of the
sum of all data values in the graph. [Area, Bar, Line, Pareto, Pie, Radar]
%_SERIES_NAME => The name of the data series that the data item belongs to. [All]
%_TIME_VALUE => The time value for a Time Plot data item. [Time Plot]
%_VALUE => The value of the data item. [Area, Bar, Line, Pareto, Pie, Radar]
%_XVALUE => The x value for an X-Y data item. [X-Y]
%_YVALUE => The y value for an X-Y or Time Plot data item. [X-Y, Time Plot]



You can find the ".PCXML" files here: {OracleBI}\web\app\res\s_oracle10\popbin or {OracleBI}\web\app\res\s_Siebel77\popbin

look for
<- DataLabels Font='Size:9;Style:Bold;' TransparentBackground='False' BGColor='#FFFFFFcd' BorderColor='#EEEEEE' FormatString='%_BUBBLE_VALUE'/>
After editing you have to restart the java host and the presentation service.

Till Next Time

22 comments:

Mark Nelson said...

Hi, I am very interested in this feature, but I do not see how to do it in the .pcxml.

Could you provide an example of how to put multiple values in the FormatString?

John Minkjan said...

Hi Mark,

Are you looking for somtehing like:
FormatString='Y = %_YVALUE,X = %_XVALUE, Series = %_SERIES_NAME' ?

Regards
John

Mark Nelson said...

Hi John,

Thanks for your reply. That is what I was looking for, but I don't seem to be able to do it in my pie chart in OBIEE 10.1.3.4.

Here my code example that isn't working:
<- DataLabels Font='Size:9;Style:Bold;' TransparentBackground='False' BGColor='#FFFFFFcd' Position='OutWithLeader' ShowSeriesTextType='NameBelowValueOnGraph' BorderType='None' FormatString='Y = %_YVALUE,X = %_XVALUE, Series = %_SERIES_NAME'/>

John Minkjan said...

Hi Mark,

This doesn't work for Pie-Charts because of the nature of a pie chart. For Piecharts you have to work with: ShowSeriesTextType='NameAndValue' {ValueOnly/NameOnly/NameOutsideValueInside} and ShowAsPercentageType='Total' {None}

regards

John

thomas said...

Great, you can even add \n \t for better formatting.
One point nevertheless, is there a way to display a label associated to the point itself?
For example with hotel data, if the serie is the Hotel chain name and every point corresponds to one hotel, how can I display the hotel name in the tooltip ?
(in your blog post, this would correspond to the license plate number)

I am feeling a little bit stupid with the impression that they forgot the most important item to display...

John Minkjan said...

Hi Thomas:

Try: %_CATEGORY_NAME => The name of the category that the data item belongs to. [All, except, X-Y and Time Plot]

Regards
John

Mohan Kumar S said...

Hi John ,

I have a problem in pie chart, when i display percentages always , it overlaps when values are near by or when more values are there.

Can you please suggest any solution for this problem,,i appreciate any help,,

Thanks,
Mohan

John Minkjan said...

Hi Mohan,

The only way you could avoid that is to organize the date in such a way that the small portion are opposite of each other

regards

John

Anonymous said...

Hi John,

I need to have the Level Axis as label on my Scatter. Do you know the code for this one?

I thought this might correspond to '%_CATEGORY_NAME', but when I use this code, I just get %_CATEGORY_NAME as label.

Many Thanks

John Minkjan said...

@Anonymous,

In Scatter/Buble graphs you only can use 'Y = %_YVALUE,X = %_XVALUE, Series = %_SERIES_NAME, BubbleValue = %_BUBBLE_VALUE '

Regards John

Marielle van der Sterren said...

Hi John,

I want to see name, percentage and value in my pie chart. What do I need to do to get this in. I created my own piebla.pcxml, changed all other files. I now see the piebla in my chart list in Obiee, I put ShowSeriesTextType='NameAndValue' ShowAsPercentageType='Total'
in the file, but I still do not see the name, percentage and the value in my pie.

Regards Marielle

John Minkjan said...

@Marielle van der Sterren,

Not really sure if that will work with corad 5.1 Why don't you drop me a line on John punt Minkjan apenstaartje ciber punt nl.

parag said...

Hi John, Can u pls tell me step by step how to show both value and % on hover for a pie chart.

John Minkjan said...

@Parag,

You can't, the CORDA engine can't handle it.

Analytics Partners said...

Hello, I am currently working on a Scatter chart and was able to use the above information to display the X and Y in a hover over. However is there an ability to display the Z axis in a hover over? For example in the above I would want the License plate number to appear in the hover over.

Thanks!

Jon

John Minkjan said...

@Analytics Partners,

OBIEE 10g doesn't have a Z-axis, wait for 11g realease 2

regards

John

psuelementjavascript:void(0) said...

Hi John,

Do you know if there's a way to display the labels on mouseover for a bar chart or a line chart?

Thank you

John Minkjan said...

@psuelementjavascript,

Works the same as this, just an other PCXML file.

regards

John

psuelementjavascript said...

Hi John,

Thank you for response.

Limbok said...

Hi John, It doesn't seem possible but could I update linecolumn.pcxml to change the DataLabels to show the value from a different column/series...if so, what would be the syntax? e.g if I wanted Y-axis to show values from X or Y2 axis or better still a hidden column from a matching case/if statement?

John Minkjan said...

@Limbok,

no you can't. The PCXML file doesn't control the data, only the look and feel.

Regards

Anonymous said...

Hi John,
have you got any idea how we can modify the scatter chart data labels in OBIEE 11g? I believe the chart engine is completely different, and I haven't found information on this.

Best regards,
Ilmari