How can I display the query execution time for a particular
DP on Web-I report? Or is there any other way to know
the 'exact query execution' time at BO end?

Answer Posted / sivakumar.v

1. Go to edit Report, run the particular query in adhoc basis, and re-run the same query you can view the refresh time on it.

2.You have a function =LastExecutionDuration() in the report level
Returns the time in seconds taken by the last refresh of a data provider .

Is This Answer Correct ?    2 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between slice and dice and cross tab report?

823


Differences between business objects and web intelligence reports?

845


can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?

1136


how to create metric universe ?

2081


what is universe null

2176


What is the dense rank?

839


What is the difference between business requirement document and use case document.

772


Explain the difference between union and group?

821


Explain how we drill up week to month?

828


How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

767


I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.

3206


Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

753


What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?

2603


Explain about alerts in bos, under what situation we need to use alerts?

757


What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?

1786