Siebel Business Analytics Server Administration Guide > Completing Setup and Managing Repository Files >

Constructing a Filter for Query Results

Use the Query Repository Filter dialog box to filter the results in the Results list of the Query Repository dialog box.

The Query Repository Filter dialog box contains five columns: an Item column and an operator/selection column to its right, a Value column and an operator/selection column to its right, and a Delete column, that lets you delete the highlighted filter.

To access the Query Repository Filter dialog box

1. From the Tools menu, choose Query Repository.
2. In the Query Repository dialog box, select an item in the Results list or select an item from the Type list, and then click Filter.

To construct a filter

1. From the Tools menu, choose Query Repository.
2. In the Query Repository dialog box, select an item in the Results list or select an item from the Type list, and then click Filter.
3. In the Query Repository Filter dialog box, click the Item field.

   The Item drop-down list contains the items by which you can filter.

4. In the Item drop-down list, select the filter that you want to apply to the Results or Type object you selected in Step 2.

   Depending on what you select in the Item drop-down list, other options may become available.

To construct a filter to view all databases referenced in a business model

1. From the Tools menu, choose Query Repository.
2. In the Query Repository dialog box, select Database from the Type drop-down list, and then click Filter.
3. In the Query Repository Filter dialog box, click the Item field.

   The Item drop-down list contains the items by which you can filter.

4. In the Item drop-down list, select Related to.

   The equals sign (=) appears in the column to the right of the Item field.

5. Click the ellipsis button to the right of the Value field, and in the drop-down list, choose Select object.
6. In the Select dialog box, select the business model by which you want to filter, and then click Select.

   Your selection appears in the Value field.

7. Click OK to return to the Query Repository dialog box.

   The filter appears in the Filter text box of the Query Repository dialog box.

To construct a filter to view all Presentation layer columns mapped to a logical column

1. From the Tools menu, choose Query Repository.
2. In the Query Repository dialog box, from the Type drop-down list, select Presentation Column and then click Filter.
3. In the Query Repository Filter dialog box, click the Item field.

   The Item drop-down list contains the items by which you can filter.

4. In the Item drop-down list, select Column.

   The equals sign (=) appears in the column to the right of the Item field.

5. Click the ellipsis button to the right of the Value field, and in the drop-down list, choose Select object.
6. In the Select dialog box, select the column by which you want to filter and click Select.

   Your selection appears in the Value field.

7. Click OK to return to the Query Repository dialog box.

   The filter appears in the Filter text box of the Query Repository dialog box.

   You can construct more than one filter; when you do, the Operator field becomes active. When the Operator field is active, you can set AND and OR conditions.

TIP:   If you are constructing a complex filter, you may want to click OK after adding each constraint to verify that the filter construction is valid for each constraint.