MicroStrategy Filter Question

1.what is a filter and their types? 2.why do we use filters ? 3.what are the filtering options?

Showing Answers 1 - 27 of 27 Answers

Vinod

  • Mar 19th, 2012
 

Filters are of two types

1. View Filter
2. Report Filter.

  Was this answer useful?  Yes

sivaleela prasad

  • May 30th, 2012
 

Filter is used to restrict the data retrieved by the report from the data warehouse. there are seven types

1)Report filter (center right) : report filter is before execution of the report include in the "where" clause in the SQL so effect on the SQL

2)View filter (top right): view filter is after execution of the report . include in the "having" clause in the SQL . so no effect the SQL

3)Report limit : report limit is apply the metric calculation .it is used how much data is restrict .

4)Security filter :

5)Standalone filter: if a create a filter folder .it is a reusable in other reports.

6)Embedded filter :if a create a filter. it is not reusable in other reports.

7)Relationship filter : if we want get the data from unrelated attributes in a system hierarchy.

  Was this answer useful?  Yes

praveen

  • Nov 29th, 2013
 

Report filter: this filter applies a where clause in a sql query and sent to the datawarehouse to fetch the results.

view filter: this filter applies after the excution of the report once the data is fetched from the dwh. it does not effect the sql.

standard filter: once the filter are created and it can be reused to multiple reports is called standard filters.

Relationship filter: we can get the results if we have the attributes relate to each other by parent child relationship. But when we want to get the data with unrelated attributes here relationship filter comes into picture. Here we need to relate these attrinbutes with fact table.

  Was this answer useful?  Yes

Shiva

  • Aug 7th, 2014
 

Attribute is a characteristic feature of an column/ columns of the database.
Whereas Measure is the value of the attribute.

  Was this answer useful?  Yes

ram

  • Nov 17th, 2014
 

view filter does not effect the s.q.l and it data fetches from analytical engine. so there is no changes in s.q.l...

Analytical engine calculation steps:
1. Evaluate view filter

  Was this answer useful?  Yes

s.a.r.khoushik

  • Dec 7th, 2014
 

filter is a condition on report , it restricts the data from database, filters are 4 types

1) Report filter or static filter
2) Stand alone filter
3) View filter
4) Report limit filter

stand alone filter can use any where in the project,,

  Was this answer useful?  Yes

DILEEP KUMAR

  • Feb 26th, 2015
 

filters: its a part of data ,screening the data &simplifying the data ,restrict the data &report

types of filters:filter definition,embed-ad filter,stand alone filter,view filter*,report filter*,copy &shortcut filter,relationship filter,security filter,dynamic filter,prompts filter,operation filter.

important:Report filter:before execution of report to report
filter at d.w.h.
its use in sql
its high performance
while execution.
view Filter:after execution of report to report
filter at analytical engine
its not use in sql
low performance
after execution.

  Was this answer useful?  Yes

yanli

  • Apr 22nd, 2015
 

Depends on the application scenarios, two types: report filter and view filter
report filter is used to restrict data from db, filter expression can be based on attribute/metric. it can be attribute qualification, metric qualification, relationship filter, joint element list, custom expression, and also can come from other report or standalone filter. report filter can be created static also be dynamic (prompted). in addition, there is another term named "report limit" which also used to qualify data from DB, but this is based on aggregated Metric and implement after the report filter.
View filter is to define what data will be present to end user. it is at Analytical engine end, not SQL engine.

  Was this answer useful?  Yes

nikhil

  • Jul 28th, 2015
 

Report filters: Report filters are the conditions that accompany the report generating SQL statements. The report definitions have the filters as part of their definition.

View Filters: View Filters are the conditions that come into play before a specific result is presented to the user. Thus the view filters are not part of the SQL statements like report definitions, rather they are the filters applied after the execution of the SQL statements, after the data is retrieved from the data warehouse.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions