jagadeswarreddy.palagani

• Sep 5th, 2005

 

In DESIGNER Level  
1)eliminate the unnecessory joins  
2)use conditions as much as at the database level  
3)edit the SQL query in the Query Panel as per requirment 
 
In REPORTER level 
 
1)eliminate the filters as much as possible  
2)try to reduce the user variables  

Suresh

• Jun 25th, 2006

 

Dear Mr. jagadeswarreddy
In REPORTER level: "By eliminating the filters as much as possible", how the performance level is increased. I donno could you plz explain me.

Latha03

 Profile Answers by Latha03 Questions by Latha03

• Jan 25th, 2007

 

Avoid applying filters unless and until there is a requirement from client side. Thus we can increase the performance of the reporter.

Nidhii

 Profile Answers by Nidhii 

• Mar 12th, 2007

 

Hi,
I can explain why a report performance is increased when we apply a filter at the universe level rather than at the report level
When we apply a filter in the universe level,after the query is fired,the data is filtered and then the required rows returned
But when the filter is applied at the report level,the query is fired,rows retrieved and then filtered by the report level filter.
In the first case(universe level filter),less rows are retrieved from the database whereas in the second case(report level filter),data is fetched and then filter applied. It is more time consuming and the performance is affected.

Hope this answers ur query
Regards,
Nidhi