MicroStrategy ONE
Filtering data based on attribute relationships or metrics: Set qualifications
This type of filter allows you to generate data in a report based on a set of attributes. The set of attributes is generated dynamically based on either the metrics associated with those attributes or the relationships between the attributes.
For example, a metric set qualification might limit the data displayed on a report to sales numbers for only those products whose current inventory count falls below a certain number. The system must first generate the set of products with the specified inventory count; then it can generate the sales numbers for that set of products.
A relationship set qualification might limit the data displayed on a report to those bank customers who have checking accounts but not savings accounts. In this example, the system must first generate the set of customers with checking accounts; then it can generate the subset of those customers without savings accounts.
For details and steps, see:
