MicroStrategy ONE

Types of Qualifications

A filter is composed of at least one qualification. Qualifications are the actual conditions that must be met, for example, "Region = Northeast" or "Revenue > $1 million". You can create multiple qualifications for a single filter, and then combine the qualifications using the logical operators AND, AND NOT, OR, and OR NOT.

You can create the following types of filter qualifications:

  • Attribute qualification allows you to filter on an attribute's form (ID, description, and so on) or on elements of the attribute.
    • An example of an attribute form qualification is a condition on the attribute form Customer Last Name for last names that start with the letter H.
    • An attribute element list qualification on the Customer attribute consists of a list of customers.
  • Set qualification allows you to create a set of attributes based on either the metrics associated with those attributes (a metric qualification) or the relationships between them (a relationship qualification). For example:
    • A metric qualification allows a report to display the sales data for only those products with inventory level below a specified value. It is also referred to as a metric set qualification.
    • A relationship qualification can be used to create a report that displays all the stores selling Nike shoes in the Washington, DC area. It is also referred to as a relationship set qualification.
  • Shortcut-to-a-report qualification, also known as a report qualification or a report as filter, uses the data from one report as a filter inside another report.
  • Shortcut-to-a-filter qualification, also known as a filter qualification or embedded filter, uses an existing filter, either as is or with additional conditions, on a report.
  • Advanced qualifications allow you to create the following:
    • Custom expressions, which are customized filter expressions. You can use Apply functions and you can create relationship filters.
    • Joint element lists, which join attribute elements and then filter the result sets.

      By default, the Advanced Qualifications option is not displayed in the Filter Editor. You must activate it first, using the My Preferences dialog box. For steps, see the MicroStrategy Web Help or the MicroStrategy Developer Help.

      The Building Query Objects and Queries, for Designers chapter of the Basic Reporting Help provides the fundamentals of creating all these types of filters, except for advanced qualifications.