we have one report. if i run the report then it will take 2 to 4 hrs.
I have checked main query & formula columns, all the query reading the index.
How can i Tune this report & how can reduce the running time.
Pls help me.
10-11 Source: Network gathering Views:0
Hi Gurus, I have an Oracle Apps Reports 6i with a formula column having so much of conditions making the reports to take long time to get completed. Its taking 20 mins to complete. Please your help on this. Thanks, GenooHi what is your database versi
Dear All, we have one report. if i run the report then it will take 2 to 4 hrs. I have checked main query & formula columns, all the query reading the index. How can i Tune this report & how can reduce the running time. Pls help me.Wrong forum, be
hii frnds, can anyone plz tell me the performance tunning in extraction,in report,in dataloading.plz reply me in pointwise.. Thanks Rosy Please search for available information before posting. Edited by: kishan P on Jan 24, 2012 10:57 AMHi Rosy, P
Dear Experts, I am urgently looking forward to some comprehensive documentation on Performance tunning elaborating on the issues like:- 1.)In what instances should we do performance tunning.... 2.) why it is neccessary and 3.) what r the <b><u>
Hi All, We are using OBIEE 10.3.4 version on windows envorinment .In our OBIEE project we are using 9 reports my requriment is we need to do performance tunning for OBIEE side.For eace report accessing its taking around 80 sec.We need to decrease the
Hi experts, I am doing Performance for a Report (getting time out error) Please see the code below and . while looping internal table IVBAP after 25 minutes its showing time out error at this poit -> SELECT MAX( ERDAT ) . please send alternate code
Dear BW experts, We have created a new BEx 3.x report, which contains about 6 queries, and 2 pre queries. The report runs very slowly, the upload time is about 40 seconds. The report itself contains one tab with 11 tables. The MultiProvider that the
How to improve the query performance in to report level and designer level......? Plz let me know the detail view......first its all based on the design of the database, universe and the report. at the universe Level, you have to check your Contexts
Hi all, In one of our queries (3.5), we had to use lots of cell definition. And after execution of the report, it stays in "Formatting Result Area" and "Retrieving Result from BW Server" for a very long time (about 30 minutes). There i
Hi, I am using one customized Function Module whithin a loop of internal table containing fields of PROJ table for about 200 records . And in the source code of function module there is set of select queries for different tables like COSS COSP , AU
Hi Friends, Can you please give me the exact answer for the below question. Suppose my report program is taking long time to execute, what are the reasons that may effect the report. and what are the remedies should i follow, please provide appropria
Hello, We have one procedure that takes 3 input parameters and returns Cursor from Procedure that is used to design the report. There is no caluculation involved here and cursor is opended dynamically. We are using Oracle Native connection. When we c
Hi, We have a requirement for a report where we will give user a set of objects (26 u2013 31) to do analysis using interactive viewing feature. Here we are facing severe performance issues and memory issues as the data that we are calling is huge( ar
Hi, -I have to design a crystal report with best possible optimization. Optimization is main concern since report will run against 1-2 million data set. Though I am using parameter to fetch only the required data, required data can go till 1 million
Hi friends, I am himansu, i am facing a problem during performance tunning of query in oracle , please guide me how to tune a query which will give better performance.907977 wrote: Hi friends, I am himansu, i am facing a problem during performance tu
Hello Experts, How do we analyse the performance of a report or a transacton in SAP. I want to know thetransactions and the steps that needs to be followed in order to get this. points are guaranteed... thanks sankarhi, SE30 - gives you a run time an
Hi Experts I have a REPORT object, having a few SELECT Queries in it. I need to analyze the PERFORMANCE of this REPORT object. How can I analyze the performance of a SELECT Query alone in it - that is time taken to execute this SELECT Query alone? Ho
can any body tell me how to increase the performance of a report?//// i have prepared a report to show the expense detail .I have used BSIS and BSAS table. But whenever I am executing it is facing runtime error (TIME_OUT error ). Moderator Message: D
Hi friends, In the loop statement I am using modify statement for updating the data in the internal table . I have to improve the performance of a report. is there any alternative for Improving teh performance., Regards, JayanHI If u r modifying Ztab
HI Experts, can you suggest me, how exactly performance is checked. what is the measure we considered for performance check. what are ideals status of the performance check for a certain program. that is, how much should be database use, abap use and