Define Attribute Filter

When you have selected the Filter Type as Attribute, define the Filter conditions by doing the following in the Attribute Selection section:

  1. Select the required Dimension from the drop-down list.
  2. Select the associated Attribute from the drop-down list. The list consists of only Dimension Type attributes for selection.
  3. Click the Show Attribute icon in the Attribute Values grid.
    The Attribute Values window is displayed.
    In the Attribute Values window, the Dimension field under Dimension grid is auto populated with the Dimension name with which the selected Attribute is defined and is non-editable. In the Search grid you can search for Attribute Values depending on Alphanumeric Code, Numeric Code, or Name.
  4. Select the checkbox(s) adjacent to the Alphanumeric Codes of the required Attribute Values in the Attribute Values grid and click OK. The Attribute Values grid displays the selected attribute values.
    Select Attribute Value(s) in the Attribute Values grid and click the Delete icon to delete it.
    You can use the Attribute Values present in the Attribute Values grid to generate conditions.
  5. Click the Add button in the Attribute Values grid. The Filter Conditions grid is populated with the filter condition using all the Attribute values.
    You cannot define two conditions using the same attributes. Because conditions are joined with a logical ‘AND’ and this will make the query invalid.
    In the Filter Conditions grid, you can select a condition to view the Attribute Values used to generate it and can update the condition.
    You can also click View SQL button to view the SQL statement in View SQL window. Click the View Attributes button to view a long filter condition in View Condition dialog.
  6. Click Save. The Attribute Filter definition is saved.