5 Replies Latest reply: Dec 5, 2012 9:27 AM by 945284

# Urg : Show data in a graph in Obiee 10g.Want to show data between a range.

Hi Team

We have a requirement .wherein we want to list out the Job Names in the Y axis and the time for which they were running in the X-axis .We have the Start time and End time of the job.So we want to show the graph in Horizontal graph from the start time to the end time.But when we put start time and end time in X axis we get separate bar for both.
But the requirement is to show the graph in the X-axis between the start time and end time for all the jobs in the Y-axis. Please guide

Regards
• ###### 1. Re: Urg : Show data in a graph in Obiee 10g.Want to show data between a range.
Hi,
Generally we will show the measures on the Y-axis but how can you show the job names on Y-axis.Is it reasonable graph.We cant measure anything with graphs.Better to change the type of the graph.

thanks,
prassu
• ###### 2. Re: Urg : Show data in a graph in Obiee 10g.Want to show data between a range.
Hi Prassu

In the X-axis we want to show the Job names and in the Y-axis we want to show the timings when the jobs were running.( i.e between the start time and end time ) .
Say for example Job A has a start time 2 'o' clock and end time 3 'o' clock ,then against Job A we want to show that the Job has run between 2 and 3 inform of a bar or horizontal chart .

Regards
• ###### 3. Re: Urg : Show data in a graph in Obiee 10g.Want to show data between a range.
It happens because the 2,3.. values are integer/double values so that we can display.
• ###### 4. Re: Urg : Show data in a graph in Obiee 10g.Want to show data between a range.
Sounds to me that you're looking for a Gantt Chart.

Refer: http://obiee101.blogspot.com/2007/12/obiee-duration-between-events.html
http://oraclebizint.wordpress.com/2007/12/06/oracle-bi-ee-101332-marquee-images-and-gantt-charts/