Creating Cascading Prompted Filters Within a Section
Defining and Applying Prompted Filters
-
The data item associated with the prompt filter allows the user to see its values. (The data source creator sets this in the information map using SAS Information Map Studio. To verify this in SAS Information Map Studio, select Properties on a data item. In the Value-Generation Method tab, the User selects values from a dynamic list option should be selected.)
In SAS
Web Report Studio, you can set the prompt type to dynamic in the Custom Filter dialog box by selecting the Dynamically generate values option from the Prompt type drop-down list.
A non-prompted
filter can be included in a cascade if it begins the cascade. However,
it will not appear in the prompts window.
Ordering Prompted Filters
You can
order all applied prompted filters, whether they participate in a
cascade, using the Manage Prompts dialog
box, which is available from the Section Filters dialog box.
Note: Only certain
users can manage prompts. If you have questions about your authorization,
contact your system administrator.
The Prompt
Order section enables you to specify the order in which the prompts
appear on the prompts window or any other window where values for
prompts need to be filled in. To reorder, select the prompt that you
want to move, and then click 
or 
to move the prompted filter up or down in the order.
If prompts are in a cascade, the prompts should appear consecutively
in cascade order. However, you can put the prompts in any order.
or to move the prompted filter up or down in the order.
If prompts are in a cascade, the prompts should appear consecutively
in cascade order. However, you can put the prompts in any order.
Defining Dependencies Between Two Prompted Filters
A cascade
relationship is defined between a prompt contained in one prompted
filter and another filter.
For example,
Filter 1 is called
City Filter and contains the prompt called City Prompt, and Filter 2 is called State Filter and contains the prompt called State Prompt. To define a cascade between the filters, you would specify that City Prompt depends on State
Filter. Note that the information that would be
displayed by the prompt is always a subset of what would be displayed
by the filter.
You can
define dependencies using the Manage Prompts dialog box in the Prompt Dependencies section. The Prompt drop-down list contains the names of the prompts that can participate
in a cascade. The Dependency drop-down list
contains the names of the filters that can participate in a cascade.
The cascade
definitions do not have to appear in any particular order. However,
when you click OK, a check is performed to
ensure that there are no circular dependencies or other illegal cascade
definitions.
To remove
a cascade, select an entry in the Prompt Dependencies area and then
click Remove. If you remove a cascade that
was a part of a chain, then the chain is not repaired to skip the
missing item. For example, you have three cascade definitions where
ZIP code depends on City, City depends on State, and State depends on Region. If you
remove City, which depends
on State, then the definition
is not altered to make ZIP code somehow dependent on Region.
Supplying Values for a Cascading Prompt
When cascading
prompts appear on the prompts window, each dependent prompt is disabled
until you supply the information for the filter that the prompt depends
on.
In the
following display,
CENTRAL has
been selected for the Region prompted filter, so the State prompt has been populated with states that are in the central region
and the State prompted filter
is enabled.
