MicroStrategy ONE

Creating custom group attribute element list qualifications

In a custom group, an attribute element list qualification allows you to qualify on a list of attribute elements. For example, an attribute element list qualification on a Year attribute might return data only for the elements 2022 and 2023.

For more information and examples of attribute qualifications in general, and specifically attribute element qualifications and attribute form qualifications, see the Basic Reporting Help.

Prerequisite

This sub-procedure assumes that you have already begun creating an attribute qualification for a custom group. If you have not, see To create a custom group attribute qualification.

To create a custom group attribute element list qualification

  1. In the Attribute Qualification pane, select an attribute in one of the following ways:

    • Type the name of the attribute in the Attribute box and click OK.

    • Click ... (the browse button) to select an attribute from the Attributes folder. Click OK.

    • Drag the attribute from the Object Browser into the Attribute box.

  2. Select Elements from the Qualify On drop-down list.

  3. Select either In list or Not in list from the Operator drop-down list.

  4. Click Add to create the list of elements. The Select Objects dialog box opens.

  5. In the Available objects list, select the elements to include in the qualification. Click > to add them to the Selected objects list. For instructions to search for elements, see Attribute Qualification: Select Objects dialog box.

  6. Click OK to close the Select Objects dialog box.

  7. Finish creating the attribute qualification, beginning at this step.

The number of elements that can be included in the Filter Editor and the SQL Engine is unlimited. However, your warehouse database may limit the number of elements of the In list SQL statement that the engine generates. This limit depends on the database and it is applied when the SQL is executed.