Last Refresh - where does it come from?

[jaburke]

In our webi reports, there is a field called 'last refresh' with a date that is displayed upon refreshing the report. Where does this time come from? Ours has somehow gotten hosed and the time isn't correct anymore.
Any help would be great! THANKS!

 

[skrandel]

It should come from the WebI server. Check the time there.

Steve Krandel
VERITAS Software

 

[jaburke]

No, the server time itself it correct.
Any other ideas?

 

[balves]

What function are you using to produce the time? There's a difference between CurrentTime() and LastExecutionTime(). CurrentTime() will be the time that the report finished refreshing. LastExecutionTime() will be the time that the report began refreshing.

Put both on a report that takes 5 minutes to refresh and the variable using LastExecutionTime() will show a timestamp 5 minutes before the variable using CurrentTime().

 

[jaburke]

That's the thing - it just shows up on all Webi reports. I don't know how it is being produced! That is what I want to know. It isn't a confusion between current and last execution b/c it is always about 5 hrs off the correct time. Any other ideas? Thanks!