MicroStrategy ONE
Attribute-to-Attribute Qualification
An attribute form is descriptive information about a business attribute. For example, the attribute Customer can have the forms First Name, Last Name, Address, Email Address, and so on. A form is a descriptive category for any data that your organization saves about any of its attributes. Just as an attribute element is a distinct occurrence of an attribute, a form defines the attribute.
Attribute-to-attribute qualifications allow you to compare attributes based on the value of their attribute forms. For example, you can return data for only new customers whose First Order Date is equal to their Last Order Date. For a more detailed example, see the Advanced Reporting Help.
The procedure below shows you how to create a stand-alone attribute-to-attribute qualification filter.
To filter data using an attribute-to-attribute qualification
- Click Create on any page, and select New Filter. .
- In the pane on the left, navigate to the first attribute whose form you want to use to filter report data.
- Right-click the attribute and select Add to Filter.
- If DHTML is disabled, select the attribute and click Add > to add the attribute to the Filter panel.
- Click Qualify.
- From the first drop-down, select the attribute form to use to filter the data.
- From the second drop-down, select the operator that describes how you want to filter data, such as Equals or Less Than.
- Click the Select Attributes icon .
- Navigate to and select the second attribute to use in the comparison.
- Click OK.
-
In the last drop-down, do one of the following:
- Select an attribute form for the second attribute. This is the value that will be compared against the form of the first attribute.
- To select a different attribute for the comparison, click New Attribute.
- Click the Apply icon .
- Click Save.
The filter that you created can now be added to a report. For steps, see How to Add a Stand-Alone Filter to a Report.