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