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:
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?
Hi Mark,
Are you looking for somtehing like:
FormatString='Y = %_YVALUE,X = %_XVALUE, Series = %_SERIES_NAME' ?
Regards
John
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'/>
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
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...
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
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
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
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
@Anonymous,
In Scatter/Buble graphs you only can use 'Y = %_YVALUE,X = %_XVALUE, Series = %_SERIES_NAME, BubbleValue = %_BUBBLE_VALUE '
Regards John
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
@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.
Hi John, Can u pls tell me step by step how to show both value and % on hover for a pie chart.
@Parag,
You can't, the CORDA engine can't handle it.
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
@Analytics Partners,
OBIEE 10g doesn't have a Z-axis, wait for 11g realease 2
regards
John
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
@psuelementjavascript,
Works the same as this, just an other PCXML file.
regards
John
Hi John,
Thank you for response.
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?
@Limbok,
no you can't. The PCXML file doesn't control the data, only the look and feel.
Regards
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
Post a Comment