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 stored procedure ? What is the need of stored procedure ? How to create a stored procedure Universe?
WHAT IS CARDINALITIES OF JOIN?
How to check for a particular value from one column with the list of values present in another column in Webi reports?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
What is the difference between condition & filter?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
GENARALLY WHAT ARE THE PROBLEMS ARE FACING WHILE CREATING REPORTS?
can we cretae views in universe level?
Hi friends, I am trying to create OLAP connection in IDT. I am getting error "error code:405 METHOD NOT ALLOWED" I am using "http:<servername>/olap/msmdpump.dll" I am using ms sql server 2012 -- cube
Briefly describe the steps you would take to use an Excel file as data to join a Business Objects data provider in a report? Thanks in advance....
what is dashboards? what is metrics?
Can some one say abt "ALL" in prompt .. How to get the word "ALL" in the prompt along with the list of values? Plz give me the steps?