Bookshelf Home | Contents | Index | Search | PDF

Siebel Analytics User Guide > Filtering Requests in Siebel Answers > Procedures for Using Filters in Siebel Answers >

Using Dynamic Filters in Siebel Answers

---

Filters can be combined with other filters, or they can be based on the values returned by another request. Such filters are called subfilters. You can select any saved request that returns columns of values and use any values in that request to filter the selected column in another request. The saved request can also reference a different subject area.

To base a filter on results of another request in Siebel Answers

Display a request to which you want to add a filter.
Select the column to use as criteria for the filter, and click the Filter icon.

The Create/Edit Filter page appears.

In the Additional Options section, click the Filter based on results of another request link.

The Filter Saved on Request page appears. The name of the column to be filtered appears in the Column box.

If this is not the table and column to be filtered, specify a different table and column.
In the Relationship drop-down list, select a relationship.

NOTE:  The relationship you choose is used to compare each value in the specified column with a group of values from another request that you specify.

To navigate to a saved request, do one of the following:
Click the link Select Request from Catalog.
Enter the complete path to the saved request directly in the Saved Request box.

NOTE:  If the saved request contains a matching column name, it appears as the default in the Use Values in Column drop-down list.

In the Use values in Column drop-down list, select the column from which to use values in the filter definition.
Click Finished.

Bookshelf Home | Contents | Index | Search | PDF