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?



How can I display the query execution time for a particular DP on Web-I report? Or is there any ot..

Answer / 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

More Business Objects Interview Questions

I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

0 Answers  


how we improve the performance of report and universe?

4 Answers   Accenture, IBM,


Explain how many universes can be created in a project?

0 Answers  


1) How can you use slowly changing dimension type 2 in Universe, Reporting and what would be the build process. 2) How can you identify the users in webintelligence not using the reports past few months. And delete them. 3) How can you move documents from one environment to other environment

3 Answers   Hexaware,


how to test the reports if there are multiple sql statements?i,e if there is 1 single sql statement we can copy it and paste it in TOAD or someother tools to test it but if we have multiple sql statements in a single query????

1 Answers   IBM,






it is possible to link two universes of separate functional domain ?

1 Answers   IBM,


what is mean by lov?

4 Answers  


Analysis in business objects?

4 Answers  


If there is no common dimension? Is it possible to combine two different dataproviders?

7 Answers  


IS THERE ANY OTHER TOOL AVAILABLE TO DESIGN/CREAT UNIVERSE? EXCEPT UNIVERSE DESIGNER

3 Answers   IBM, TCS,


when and where we use @varialble function

1 Answers  


Hi All, I have found out this site very interesting and knowledge sharing site.I was wondering if you can tell me where I can get study materials for the BO XI 3.1 or suggest me the one that you have taken recently. Regards, Ace

1 Answers  


Categories