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.
|
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. |
Its very informative blog and useful article thank you for sharing with us , keep posting learn more
ReplyDeleteMulesoft Online training with 100% job Assistance and 24 X 7 Online Support. Visit us about mulesoft training | mulesoft online training
I have read Your Article and Learn a lot from it. I can Imagine the time it took to get all this expertise exposed .
ReplyDeleteServicenow Training In Hyderabad
Thank you a lot for providing individuals with a very spectacular possibility to read critical reviews from this site.
ReplyDeleteservicenow training in Bangalore
An awesome blog for the freshers. Thanks for posting this information.
ReplyDeleteMicrostrategy Training
Microstrategy Online Training
Nice and good article. It is very useful for me to learn and understand easily. Thanks for sharing your valuable information and time. Please keep updating.
ReplyDeleteMicrostrategy Training
Microstrategy Online Training