[MSTG] Comparison Of Various Types Of MicroStrategy Filters

 

Comparison of various types of MicroStrategy Filters

Report Filter	View Filter	Report Limit
Report filter is applied in report SQL.	View filter is not applied in report SQL.	Report limit is applied in report SQL.
Applies to any object present or not present in report	Applies to anything present on report only	Applies to only metrics
Applies before aggregation	N/A	Applies on Aggregation
Appear in WHERE clause	N/A	Applies in HAVING clause
Never applies in last SQL pass	N/A	Specially applied in the last pass 1
Condition is not case sensitive	Condition is case sensitive	N/A