Types of filters in Microstrategy

Types of filters in Microstrategy

Below are the types of filters:

1.Attribute qualification filter

These types of qualifications restrict data related to attributes on the report.

a) Attribute form qualification

Filters data related to a business attribute’s form(s), such as ID or description.

•

For example, the attribute Customer has the forms ID, First Name, Last Name, Address, and Birth Date. An attribute form qualification might filter on the form Last Name, the operator Begins With, and the letter H. The results show a list of customers whose last names start with the letter H. b) Attribute element list qualification Filters data related to a business attribute’s elements, such as New York, Washington, and San Francisco, which are elements of the attribute City. • For example, the attribute Customer has the elements John Smith, Jane Doe, William Hill, and so on. An attribute element list qualification can filter data to display only those customers specified in the qualification by selecting the In List option or all the customers excluding those specified in the qualification by selecting the Not In List option.

2. Set qualifications

These types of qualifications restrict data based on the value, rank, or percentage of a metric, or based on the relationships between the attributes on the report. 

Uses the result set of an existing report as is, or with additional conditions, as a filter in a different report.

a) Metric set qualification

Filters data related to a set of attributes that are determined based on the metrics associated with those attributes.

•

For example, a metric set qualification might filter data to display sales data for only those products with an inventory count below a specified number.

b) Relationship set qualification

Filters data based on a specific relationship between two attributes.

•

For example, a relationship set qualification might filter data to display those stores selling Nike shoes in the Washington, DC area.

3. Shortcut qualifications

These types of qualifications restrict data related to existing report results or an existing filter. 

Uses an existing filter as is, or with additional conditions, in a report.

a) Shortcut-to-a-report qualification

•

For example, you might use a shortcut-to-a-report qualification by taking the result set of one report showing all customers in the Southwest region, placing that result set as a filter into a new report, adding a new filter qualification for active customers in the current year, and displaying all currently active customers in the Southwest region. b) Shortcut-to-a-filter qualification

•

For example, you might use a shortcut-to-a-filter qualification by taking an existing filter for Region = Northeast and Year = 2006, placing it in a report, and adding a new filter qualification for Month of Year = December.