Bookshelf Home | Contents | Index | Search | PDF

Siebel Analytics Server Administration Guide > Setting Up and Working with a Repository >

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, which lets you delete the highlighted filter.

To access the Query Repository Filter dialog box

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 (when applicable).

To construct a filter

Access the Query Repository Filter dialog box.
Click in the right side of the blank row of the Item column.

A drop-down list displays the items by which you can filter for the object you selected in the Query Repository dialog box.

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

In the Query Repository dialog box, select Database from the Type drop-down list, and then click Filter.

The Query Repository Filter dialog box appears.

Click in the right side of the blank row of the Item column.

A drop-down list displays the items by which you can filter.

Select Related to from the Item drop-down list.
Select = in the Selection column to the right of the Item list.
Click in the Selection column to the right of the Value list.

The Browse dialog box appears.

Select the business model by which you want to filter.

Your selection appears in the Value list.

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

In the Query Repository dialog box, select Presentation Column from the Type drop-down list, and then click Filter.

The Query Repository Filter dialog box appears.

Click in the right side of the blank row of the Item column.

A drop-down list displays the items by which you can filter.

Select Column from the Item drop-down list.
Select = in the Selection column to the right of the Item list.
Click in the Selection column to the right of the Value list.

The Browse dialog box appears.

Select the column by which you want to filter.

Your selection appears in the Value list.

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 column becomes active, which lets you 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 so far.

Bookshelf Home | Contents | Index | Search | PDF