Report Run Duration

[system]

Hi,

I need to find the duration of report run time? Can someone please let me know if there is any way…

---

aniketp (BOB member since 2007-10-05)

[system]

In InfoView, you should have the option “interactive” set for the infoView display. Then, when you double-click on a report to “view” it in infoView. On one of the tabs you now have in the bottomleft corner of your report, you can see the duration of the query last time.

hope this helps

Binabik

---

pderop (BOB member since 2010-10-27)

[system]

Thanks for your help on this.

Actually I was looking to find the duration of many reports together and the solution you gave is time consuming, else I can also try to use LastExecutionTime function, can you please let me know if there is a way to find duration for multiple reports?

---

aniketp (BOB member since 2007-10-05)

[system]

Hey ! have u tried the Excel macro tool which used to give us the rep information , I remember it used to give duration info along with that , (Report ID,Folder Location, Universes Used, Categories,End Date.End Time,Duration,CUID , etc)

Thanks,
Preethi

---

preethi.psm (BOB member since 2010-07-02)

[system]

Preethi, thanks for your input, Can you please help me finding that utility or let me know the name of that utility so that I can try to search?

---

aniketp (BOB member since 2007-10-05)

[system]

Aniket,

I have an excel output alone which shows the details of reports along with duration, I have misplaced that macro file somewhere , not able to find it .

similar to that ,in BOB itself, theres an excel

XIR2 - Retrieve Report Statistics Macro

Author: Jim McGregor, james.mcgregor@zionsbancorp.com Author notes: Platform: Microsoft Excel 2003 / XIR2 SP4 Version: 1.0 (See version 1.1 here) Code: Rather than post the code verbatim, here is an overview of the logic: 1. Connect to the CMS (Thanks Julien!) 2. First Loop - Loop through the three types of reports: Crystal, Webi, Deski 2. Second Loop - Extract the list of reports. 3. Third Loop - Count up the number of instances and calculate the avg runtime. Retrieve Report Statistics …

but not sure how far it will records those details, there would be lots of macro available , if this one is not working for u search for better macro.

Thanks,
Preethi

---

preethi.psm (BOB member since 2010-07-02)

[system]

Hey Preethi, thanks for that link, but it is not working for me, I am on 3.1 and I have pasted the error there, let’s see If I can get some help

---

aniketp (BOB member since 2007-10-05)

[system]

Activity Universe? Seems like the easiest way to me.

---

mcnelson (BOB member since 2008-10-09)

[system]

Never found a proper answer for this so wanted to post this question one more time-

How do you determine report run time/ Query execution time of a report?
and let says if there are multiple queries running in the document, how do you determine the execution time for each individual queries running in the document?
LastExecutionTime() time is based on a previous run estimate and Query Summary Template(Query duration info inside it) option too is similar to last executiontime()

---

karna (BOB member since 2010-03-07)