Graph

[crackie]

Hi people,

I have a request where a user wants to monitor if there was an activity at a particular time of a day. Example, we are loading files from different substations to one server. Now I must create a graph with 0 to 23hrs, then little dots showing what time did a file load. I have two issues :

1st I've tried count files but the result show a sum of files in a particular hour. How can I show points in minutes without showing minutes in my axis.  Something like this or better if there is.


...  .   .. ... .   ... .. ...  ... ... ...    . ...      .   .. .. ........ .. .........
_____________________________________________________________________________________
0      1     2     3     4     5     6     7     8     9     10     11     12     13     14     15     16     to 23

2nd can u advise which graph can best dispaly this as Cognos 8 does not have a straigh line graph

thanking u in advance

[larsonr]

Really this depends on how your data is coming in.

Here is a trick to maybe get the data in the format you want.

When you are processing these files, store the data in the database as a decimal.  So at 1:15AM, store it as 1.25.  So now you have a fact table by day by file with these decimals which can be represented on the graph. 

In the report this is where you would get the output necessary. 

You would need to do a count of files at that decimal formatted number.  Decode it to something constant.  So if count of files is greater than 0 (it would otherwise the record wouldn't be there), then the value is to be set to a constant.  You can then set up a graph, that increments by one on the x-axis and use your value of 1 to have it draw the line at that point. 
I cannot say I have actually tried it but it appears to work when I draw it out.

We use the minute/second conversion piece a lot on our end to handle Drive Thru reporting to display into graphs.  Hope this helps to get the ball rolling.

[goose]

Does it have to be a graph? Maybe a report would do the job just as good. There is no graph in Cognos that will give you what are describing that I can think of, if you want check out jpgraph http://www.aditus.nu/jpgraph