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 |
When upgrading from 3.1 to 4.0. Which services need to run ONLY? Do ALL services need to be running?
1) How to get multi values in a single prompt? 2) How to get ALL in @prompt? 3) Select 1 from fact table? What will be the result? 4) I have created 1 universe say A and generated 100 reports on the universe? Later i had renamed the Universe as A1 and added some objects? Now how i will get the newly added objects in old reports?
In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha
1.what is context? How u create? With example.
How to Implement the the Built-in Strategy Script in BO Designer?
How to generate the report from excel sheet?
What is Custom Sorting? In development environment we had applied custom Order on Month which is having the following list of values September,October,March,August and December only.But in Production environment Month is having all LiSt of Values like 12 MOnths(Jan to Dec).So ,How it will effect the Sorting in production environmentof universe and as well as in reporting????? Thanks in advance.
What is the difference between Report Bursting and Report scheduling?Explain both of them in detail?
how can i add two different reports in the same document?
hi my question is in a report table how can we write table header without using of individual cell.can we merge column cells togrther??
Can anybody tell me what are the tuning problems?
how do u migrate BO 6.x to XI ?
52 Answers Cognizant, HCL, IBM, Wipro,