Skip to Content
0
Former Member
Feb 12, 2007 at 01:16 PM

Previous Errors

14 Views

Hi,

I have some errors(occured on a certain machine) in a cube and the date/time when the errors are recorded:

Error---- -date --


time

1--


2006/02/11----11:48:37

8--


2006/02/11----11:48:23

10--


2006/02/11----11:48:14

5--


2006/02/11----11:47:42

6--


2006/02/11----11:48:42

I want to report on previous errors within a time frame with an error as reference. So, if error 8 is my reference error and the delta time frame is 60 seconds the report has to return the following:

Error-------delta time(seconds)

10----


9

5----


41

And, if error 6 is my reference error and the delta time frame is 50 seconds the report has to return the following:

Error-------delta time(seconds)

1----


5

8----


19

10----


28

Has anyone an idea?