Filters are used to restrict the data that is returned from a
query to a
data source. Some relational and multidimensional data sources include predefined filters that
you can select for a specific
category. For relational data sources, you can also create custom category filters in SAS
Web Report Studio.
There are three types
of section filters that you can select or create:
-
filters that are applied without prompting. Values for these types of filters are
supplied when the
filter is created or edited. When a report section is viewed, these filters are applied
without prompting. If the filter was created by using SAS Web Report Studio, then
you can edit the filter to use different values. You cannot modify filters that are
defined with the data source, but you can remove them from the query.
-
prompted, or interactive, filters. The values within prompted filters are obtained
right before the report section is run. Typically, the prompts within the filters
have default values. Before the report can be displayed, you must complete a prompt
window. After the report is displayed, you can change the prompt values to see different
results. The prompt style (drop-down list, selection list, text box) depends on how
you or the data source administrator created the filter.
To change the prompt
values, refresh the report data as described in Refreshing the Data in a Viewed Report.
-
cascading, prompted filters provide different filter choices depending on a previously
selected filter value. These filters are a special
type of
prompted filter. For example, if you select
Clothing as the value for a
Product
Category filter, then the subsequent filter for
Product
Name might be restricted to choices such as
Eclipse
Sportswear,
Tracker T-shirts,
and
Green Tomato Knitwear. However, if you
select
Camping Gear as the value for the
Product
Category filter, then the
Product Name filter
might be restricted to choices such as
Orion Trekking
Poles,
Eclipse Sleeping Bags,
and
Tracker Backpacks.