RE: What are the steps to taken care to improve the Report performance?
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
RE: What are the steps to taken care to improve the Re...
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.
