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.
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.
A simple way to combine Measure and Events.
[17-DEC-2007] @George:
This is the date format:
10 comments:
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
Hi George,
All I did was set the date format to d-M-yyyy
Hope This Helps
John
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
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
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.
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
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
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
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
@Ashwini,
Check the documentation for "combined by similiar request"
regards
John
Post a Comment