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
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








1 comment: