Extra Pages

▼

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
at

22 comments:

  1. AnonymousOctober 14, 2008 at 7:13 PM

    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?

    ReplyDelete
  2. John MinkjanOctober 20, 2008 at 9:21 AM

    Hi Mark,

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

    Regards
    John

    ReplyDelete
  3. AnonymousOctober 20, 2008 at 4:04 PM

    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'/>

    ReplyDelete
  4. John MinkjanOctober 20, 2008 at 8:50 PM

    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

    ReplyDelete
  5. AnonymousDecember 3, 2008 at 11:57 AM

    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...

    ReplyDelete
  6. John MinkjanDecember 3, 2008 at 2:02 PM

    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

    ReplyDelete
  7. Mohan Kumar SMarch 13, 2009 at 5:08 PM

    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

    ReplyDelete
  8. John MinkjanMarch 17, 2009 at 1:28 PM

    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

    ReplyDelete
  9. AnonymousAugust 10, 2009 at 9:20 AM

    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

    ReplyDelete
  10. John MinkjanAugust 10, 2009 at 9:43 AM

    @Anonymous,

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

    Regards John

    ReplyDelete
  11. Marielle van der SterrenNovember 19, 2009 at 3:29 PM

    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

    ReplyDelete
  12. John MinkjanNovember 23, 2009 at 9:36 AM

    @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.

    ReplyDelete
  13. paragJune 4, 2010 at 9:59 PM

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

    ReplyDelete
  14. John MinkjanJune 17, 2010 at 8:12 AM

    @Parag,

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

    ReplyDelete
  15. Analytics PartnersOctober 6, 2010 at 5:14 PM

    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

    ReplyDelete
  16. John MinkjanOctober 18, 2010 at 2:47 PM

    @Analytics Partners,

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

    regards

    John

    ReplyDelete
  17. psuelementjavascript:void(0)February 23, 2011 at 6:31 PM

    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

    ReplyDelete
  18. John MinkjanFebruary 25, 2011 at 9:42 AM

    @psuelementjavascript,

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

    regards

    John

    ReplyDelete
  19. psuelementjavascriptMay 18, 2011 at 9:57 PM

    Hi John,

    Thank you for response.

    ReplyDelete
  20. LimbokDecember 8, 2011 at 6:33 PM

    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?

    ReplyDelete
  21. John MinkjanDecember 13, 2011 at 1:48 PM

    @Limbok,

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

    Regards

    ReplyDelete
  22. AnonymousJune 6, 2012 at 10:59 AM

    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

    ReplyDelete

Note: Only a member of this blog may post a comment.