Report Filter is applied on objects before report execution.It appears in WHERE CLAUSE & it effects the SQL
View Filter is applied on objects after report execution. It retrieves the results subset of original report, it can be viewed & designed in view mode not in design mode of the report.It does not hit the dwh / db. This is a OLAP feature.
Report limit is a pre-fetch technique applied on db level, When we use the Report limit the HAVING CLAUSE will be generated.report limit specifies a set of criteria used to restrict the data returned in the report data set after the report metrics are caluculated.
View Filter is applied on objects after report execution. It retrieves the results subset of original report, it can be viewed & designed in view mode not in design mode of the report.It does not hit the dwh / db. This is a OLAP feature.
Report limit is a pre-fetch technique applied on db level, When we use the Report limit the HAVING CLAUSE will be generated.report limit specifies a set of criteria used to restrict the data returned in the report data set after the report metrics are caluculated.
No comments:
Post a Comment