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 |
