cancel
Showing results for 
Search instead for 
Did you mean: 

Previous Errors

Former Member
0 Kudos

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?

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi

For this you should a create a variable with exit....to dynamically calculate the delta time based on the input of reference

Regards

N Ganesh

Former Member
0 Kudos

Doesn't anyone has a clue??