Thursday, February 28, 2013

[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
Applies on Aggregation
Appear in WHERE clause 
Applies in HAVING clause
Never applies in last SQL pass
Specially applied in the last pass 1
Condition is not case sensitive
Condition is case sensitive

1 comment: