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 the local filter and global filter in bo's?
What is top business?
What are the major problems will occur while migrating to the one version to another version?
Can any body Explain me what are the critical problems you have faced in the designer and repoting level in the real time environment?
What is the difference between Thin client & thick client?
how to creat 2 way drilling mode.can any one know this
Explain is data mart?
What is the use of Surrogate key in BO?
Can we Save (save as) WEBI Doc as DESKI?
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 ?
Without using OBJECTS Can i write AND run a query in webi/desi? HOW?
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