praveen_srirama

 Profile 

• Nov 15th, 2006

 

At universe level by using loop resolving technique we have a chance to improve the performance and also using the aggregate tables.

In report level removing data provider,remove unneccery formales andveriables

 

ramireddy.g

 Profile Answers by ramireddy.g 

• Dec 1st, 2006

 

At universe level 3 ways we can improve the query performance.

1. Using aggregation tables in scheme.

2. Chnge the Array Fetch parameter.

3. Using shot cut joins.

4. Puting indexes on  tables.

Jay

• Dec 16th, 2006

 

One more thing , By partioning of the Table in the Database

kiran

• Feb 23rd, 2007

 

By aggregation. Try to use less filters in the report. Use star schema grouping, check the joins. Also drill through functionality increases performance as well. Always try to use appropriate functionality which can save time in this way you can improve performance of a report.