Monday, February 16, 2009

Report filter, View filter and Report limit

Comparison of various types of MicroStrategy filters.



1 – Main reason to use Report Limit, else it doesn’t give any performance improvement compared to Report Filter (Metric based) in case of big data set to be SQLed.

2 comments:

  1. And there is of course the report used as filter, which behaves rather like the report filter, except that it only applies to the attributes, as far as I know.
    Are there other exceptions? I’m not sure about the OLAP licensing...

    ReplyDelete
  2. Report filter: Condition is NOT case sensitive? I guess this depends on the database.

    ReplyDelete

Note: Only a member of this blog may post a comment.