Extra Pages

▼

Friday, August 8, 2008

OBIEE Date Time Scatter graph

In OBIEE 10.3.4.0 Oracle gave us the date time graph. Of course we want more :-) Here is how you can make a Date Time scatter graph by editing the PCXML.

WOW: Before you start doing any editing like this BACK UP BACK UP BACK UP. Because if it goes wrong it can really F*#@$">F*#@$ your system.


Step 1: Copy the linetime.cxml file to linetimescatter.cxml. This file can ussaly be found in ..\OracleBI\web\app\res\s_oracle10\charts



Step 2: Copy the timeline.pcxml to timelinescatter.pcxml. This file can ussaly be found in ..\OracleBI\web\app\res\s_oracle10\popbin



Step 3: In the custommessages folder for the language add the following to the custommessages.xml file (create the folder and file if they don't exsist!)




Step 4: Edit the linetimescatter.cxml file
set displaynameref="kmsgChartTimeSeriesScatter"
set sawc:engineSpecific file="popbin/timelinescatter.pcxml"
Save and close the file

Step 5: Edit the timelinescatter.pcxml file

set Graph Name="graph" Type="Time" SubType="Scatter"
Save and close the file

Step 6:
restart the Java-host and the prestationserver.




Till Next Time

at

9 comments:

  1. nareshJuly 1, 2009 at 8:58 AM

    Hi John,

    i want to display tool tip for level axis in a scattered graph as like hovering over a point it is displaying the X and Y axis value , in the same way i want the actual value of column which has been taken in level axis.

    Thanks
    Naresh Meda

    ReplyDelete
  2. John MinkjanJuly 1, 2009 at 9:00 AM

    @Naresh,

    Have a look here:

    http://obiee101.blogspot.com/2008/01/obiee-xy-and-data-in-mouse-over-label.html

    regards

    john

    ReplyDelete
  3. nareshJuly 1, 2009 at 10:35 AM

    Hi Jhon,
    %_SERIES_NAME gives us the legend axis value . when i put %_CATEGORY_NAME i did not get any value in the chart rather it showed the text like Z = %_CATEGORY_NAME . Is there any syntax to follow. All other options are not for all the graph . Could you please help me out.

    Thanks

    Naresh

    ReplyDelete
  4. John MinkjanJuly 1, 2009 at 10:41 AM

    @Naresh

    Did you try %_XVALUE, %_YVALUE , %_BUBBLE_VALUE

    regards

    john

    ReplyDelete
  5. nareshJuly 1, 2009 at 10:50 AM

    Hi John,

    yes , i tried . but it is not for scattered graph . it's for bubble graph . Still then i tried with that and it displays 0 always.

    Thanks
    Naresh

    ReplyDelete
  6. John MinkjanJuly 1, 2009 at 12:47 PM

    @Naresh
    Did you check the docs in:
    {OracleBI}corda50\docs

    regards
    John

    ReplyDelete
  7. nareshJuly 2, 2009 at 10:16 AM

    Hi John,

    i went through all the available document but did not get any solution

    Thanks

    Naresh

    ReplyDelete
  8. ChrisAugust 10, 2010 at 12:33 AM

    Hi John

    I followed your instructions but in the drop down list i keep getting:

    *** kmsgChartTimeSeriesScatter: message text not found ***

    any idea on what maybe wrong?

    Thanks

    ReplyDelete
  9. John MinkjanAugust 10, 2010 at 8:10 AM

    @Chris,

    Check for typo's and Capitals!
    Restart the presentation server and javahost.

    regards

    ReplyDelete

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