BusinessObjects Board

How to display refresh Start datetime and end datetim in Des

building reports desktopintelligence
#1

Hi,
I have to monitor how much time one DeskI report is taking to refresh. So I need to add 2 variables in the Report. 1st Variable should display Refresh Start DateTime and otherone should display Refresh End DateTime. Also total time consumed (in Minute: Second) during refresh acivity.

Please Guide me the formula should be used to get the same.

Thanks in advance.

Vicky

Byomakesh :india: (BOB member since 2009-08-01)

#2

Hi,

I doubt you can do this in DeskI out-of-the-box.

What you can do is to open Data Manager and check the duration of each data provider in the report. The sum of the durations will give you the time needed for the last execution of the report.

Marek Chladny :slovakia: (BOB member since 2003-11-27)

#3

hello,

if your report has 2 or more queries, you can have the duration of the refresh of the query n°2, n°3 …

the duration of the query n°2 is the difference between

=LastExecutionTime("query2")

and

=LastExecutionTime("query1")

to get the time difference, see this topic.

azertyh :madagascar: (BOB member since 2005-10-27)

#4

Hi,
Thanks all of you.

Actually this is part of my requirement. Want to display Report Refresh Start time and Report Refresh end time in the report. Need to monitor how much time report is taking to refresh during pick and non pick hours.

In the report, I have more than 8 data providers.

Hope will get best answer.

Regards,
Byomakesh

Byomakesh :india: (BOB member since 2009-08-01)