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 are the types of errors you faced while creating a report from two different data providers
explain merge dimensions with real time in DWH?
When we are going for Shortcut join and why.
Once the project is submited to the Client. Client says that report is taking long time to run? Where u need to check?
Can anyone plz tell me How to create universe in business objects enterprise 11.5
GENARALLY HOW MANY REPORTS ARE CREATE FOR EACH ONE ?PLZ EXPLAIN AFEW FOR AUTOMOBILE PROJECTS?
what is the use of merge option in webi reports? explain with example?
Differences between business objects and web intelligence reports?
What is metrics?
How the universe is working for fetching data? when it's get connected with db or data source? what is micro cube and when it is created? Is micro cube reside in inside of the universe?
I have a column contains a data like A,A+,A++,B,B++ how u going to sort ther data?
what are the debuggings in the business objects?