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
Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....
How to create Index to the table in the universe designer and how it improves the Query performence
Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,
Explain what are the measure objects?
How to generate the report from excel sheet?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
Explain in detail about type 2(scd),
Explain about a tricky situation for which you found a very simple solution?
What Is Snow Flake Schema?
What Is The Difference Between Oltp And Olap?
Explain how many universes can be created in a project?
What is the difference between user and versatile user?
Explain what is the difference between slice and dice and cross tab report?
How to execute the plsql procedure from the report by clicking with mouse?
1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?