Attribute element list qualification

The elements of a business attribute are the unique values for that attribute. For example, 2006 and 2007 are elements of the Year attribute, while New York and London are elements of the City attribute. On a report, attributes are chosen to build the report, but once the report is executed, the attribute's elements are displayed in the rows or columns.

The filter type called an attribute element list qualification qualifies (or filters) report data based on a list of attribute elements belonging to an attribute. For example, the attribute Customer has elements which are individual customer names. For a report containing the attributes Region, Customer, and Income Range, you can use an attribute element list qualification on the attribute Customer to obtain income data for only those customers you specify in your filter.

The procedure below shows you how to create a stand-alone attribute element list qualification filter.

To filter data based on business attribute elements

    1.  

  1. On the project's main page, click Create Filter. The New Filter page opens.

  2. In the pane on the left, navigate to the attribute that has the elements by which you want to filter a report's data.

  3. Right-click the attribute and select Add to Filter.

  4. To create the list of elements which the filter will use to filter data, perform the following steps:

    1. Click Select.

    2. From the In List drop-down list, select one of the following:

    3. The Available area on the left displays the elements that belong to the attribute you chose for this filter. Select an element and then click the right arrow to move the element to the Selected area. Press CTRL to select multiple elements. If the Available list contains a large number of elements, use the Search for field to locate the elements you want to select.

      You can search for objects:

  5. Click the Apply icon Apply icon to create your filtering condition.

  6. From the File menu, select Save As. The Save As dialog box opens.

  7. Navigate to the folder where you want to save the filter. Enter a name and description for the filter in the Name and Description fields, and click OK. Your new filter is saved.

The filter you created can now be added to a report. For steps, see Adding a stand-alone filter to a report.

Related topics