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 / 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 |
can anyone help me ? an index has been done on the primary key of a table. an update operation was performed on that table. now my question is 1> what abt the performance ? means faster or slower due to indexing ? 2> does the operation affect to the primary key constraint ? normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
What is mean by tuning the report?
in sap bi we have wad, then why we go for sap bo
What are the security level used in BO?
There are 2 types of strategies are there? 1. Built-in Strategy 2. External Strategy can you please explain them in complete that what are these? Thanks in Advance
What is top business?
what are slowly changing dimensions, confirm dimensions?
use scheduler to refresh report.....explain please.....
can any one say me exactly when and where alias and context are used in resolving a loop. If possible try to give me a scenario also.
What is the definition of derived table ?
what r the universe connection types?
how to solve #multivalue, #syntax, #error. iwant complete solution process in practical wise?