Thursday, December 6, 2007

OBIEE Measures and Events in one chart


Recently I had a question from a customer, a truck management company. They collect electronically statistics from several truck company’s. One statistic is fuel consumption.




The other one is trips to the garage:

Where 1 = Tyre change, 2 = Oil Change, 3= Fuel Filter Change, 4 = Other maintenance.




They want this data combined in one chart, to see if a trip to garage has an influence on the fuel consumption.



First I combined the data into one view using UNION ALL and a couple of dummy columns. If I have an event for that date I put in a 10 else NULL.

Then I put this into a Line Bar Combo Graph





A simple way to combine Measure and Events.

[17-DEC-2007] @George:


This is the date format:



10 comments:

Anonymous said...

Hi,

How have you managed to get dates to be displayed along the x-axis in a timeline fashion?

I am trying to produce a similar chart, and have not been able to display the date values along the axis.

Thanks in advance,
George

John Minkjan said...

Hi George,

All I did was set the date format to d-M-yyyy

Hope This Helps

John

Anonymous said...

Thanks John,

I have tried that but to no avail.

To give you some more information on what it is we need to do:

Our tool is being used to report project progress. We have a number of projects, each of which has a planned start date and a planned end date.
The requirement is to display these dates on a timeline (similar to a gantt chart).

Do you think we are we going about this the correct way?

Thanks for your help,
George

John Minkjan said...

George,

You also could try a vertical bargraph, or a stepped graph. I will try to work out an example during this week.

HTH

John

Neeraj said...

We are trying to custmize the Y-Min and Y-Max values which should be customizable rather than based on fetched values. Is there a way ?
Example : The user sees some facts which always varies between values 4.2 to 4.4 (4 decimals). Can we set this as the scales for Y-axis rather than it automatically finding it.

John Minkjan said...

Neeraj,

The graphics parser from OBIEE doesn't allow you to set the axis scale dynamicly. I tried hacking around it, but it doesn't regonize the XML.....You could set the axis scale to Zoom to data range....If you fire the report from an iBot you could script the report XML every time you run the report to your desired values.

Hope This Helps

Stijn said...

Hi John,
do you know if this workaround can also be used with the new time series graph in the latest release of OBIEE (10.1.3.4).
It seems that this graph does not support a line bar combo with time series..

Regards,
Stijn

John Minkjan said...

Hi Stijn,
No that doesn't work with the new TimeSeries graph. The Corda engine doesn't have a TimeLineBar graph, which can communicate with OBIEE 10340. (I already treid hacking around it.... :-( ) You will have to create an event a second before the event needed with a value below the X-axis and event a second after the event with a value below the X-axis

HTH

John

Ashwini said...

Hi,

I am a newbie. Was going through your blog. You have combined the data into one view using union all. Can you please tell me the steps in detail how to create a view using union all?

Thank you,
Ashwini

John Minkjan said...

@Ashwini,

Check the documentation for "combined by similiar request"

regards

John