Managing Data Source Filters

Each data source has its own list of filters that can be used with that data source and no others - even if the others are part of the same model. This is because each filter references specific fields in the host data source, and those fields simply may not exist elsewhere.

Filters have no effect on the results of a Stored Procedure data source.

To view the filters associated with a data source:

  1. Click in the Definition panel to open the Model Data Sources window.
  2. Select the intended data source.
  3. If you plan to make changes one or more filters, check out the data source by clicking .
  4. Click Filters.

The window used to manage filters varies depending on the type of data source selected:

  • T-SQL data source filters are managed using the Filters tab at the bottom of the Data Source Query Editor window.

Use this tab to apply filters to a T-SQL data source.

  • Filters for all other types of data source are managed using the Data Source Filters window.

The Data Source Filters window, with no filters present.

To learn more about making changes to a data source's filter list, refer to the following topics:

Description Further Reading
Create a new filter for a data source. Creating a Data Source Filter
Edit the properties of an existing data source filter. Editing a Data Source Filter
Copy a data source filter. This is not possible for T-SQL data sources. Copying a Data Source Filter
Remove a filter from a data source. Deleting a Data Source Filter