What is different among of report filter, view filter and report limit?

Report filter	View filter	Report Limit
Affects SQL	Does not effect on SQL	Affects SQL
Applies to any object present or not present in report	Applies to anything present on report only	Applies to only metrics
Never applies in last pass	n/a	Specially applied in the last SQL pass
Appear in where clause	n/a	Appear in having clause
Applies before aggregations	n/a	Applies on aggregation
Not part of OLAP license	Part of OLAP license	Not part of OLAP license
Condition is not case sensitive	Condition is case sensitive	n/a