Previous Errors

[Former Member]

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?

[Former Member]

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]

Doesn't anyone has a clue??