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 |
what is local filter
how can we retrieve particular number of rows from data ware house?for EX: my report want to displayed with 10 records in a report??how
Pls say any one... how will u create a report using oracle stored procedure? could u pls send me the step.....
What is meant by ZABO and FC(full-client)?
WHAT IS SYNCHRONIZATION IN BOXI?
Aliases and Contexts Which once will give the better performence when resolve the loops?
How we drill up week to month?
What is the use of Surrogate Key in BO?
In a context can i get the data from two different factables by using the single data provider?
Tell me about linked universe ?
Can Bo generates the reports from cubical data ? Explain?
How to create Index to the table in the universe designer and how it improves the Query performence