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 are the tables used in health care domain project and columns used in report?

4038


Explain what sort of existing documents should business analysts refer to when starting on a new project?

607


Can more than 1 metric be applied on an analytic in business objects?

1659


Explain what are the measure objects?

551


what is xcelsius architecture?

3744






What are the data types present in bo? What happens if we implement view in the designer and report?

622


If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?

694


When we use aggregate awareness function in designer?

552


What we need to discuss with designer before starting the universe designing.

1822


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?

1557


How would you format some text using css to be verdana and bold?

674


Explain how to schedule the report in b.o?

567


what is universe null

1991


Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?

1572


Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?

552