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.