MicroStrategy ONE

Attribute-To-Attribute Qualification

For some purposes, you may need to filter on an attribute based on criteria related to another attribute or related to a custom expression. For example, perhaps you need to generate a report that lists customers who live in the same city as call centers in your company. In this case, you qualify on the Customer and Call Center attributes using an attribute-to-attribute qualification filter. (See Example: Customers Who Live in the Same City as Call Centers for steps to complete this example.)

In another scenario, your next marketing campaign is targeted towards customers with income in a certain bracket. This requires an attribute-to-attribute qualification filter to qualify on the Income Bracket attribute, but in this case, the second item qualified on is a custom expression instead of an attribute. (See Example: Filtering on an Income Bracket for steps to complete this example.)

Attribute-to-attribute qualification filters always require the use of custom expressions, which are touched upon briefly in this section. For a more comprehensive discussion of custom expressions, Apply functions, and examples, please refer to Custom Expressions.