Though both report filter and report limit are calculated by SQL engine (and hence they appear in sql view), when fetcing data from datawarehouse , report filter is applied before fetching the data from data warehouse and report limit - after fetching the data from the warehouse.
- Report limit is used to apply restrictions on metric calculations. Thus, only after all the metrics are calculated , report limit can be applied.
As metrics are the results of aggregations on facts , hence having clause is used to restrict the result.
- However, Report filters define the criteria to select the data that will be used to calculate the metrics. Hence, where clause comes into picture.
Hope this helps...