To ensure that the
prefilter and required table assignments are working as expected,
test the information map again:
-
On the
toolbar, click
.
-
In the
Test the Information Map dialog box, select
Name,
Department,
Location,
Number of Years Employed, and
Which department? from the
Available items list if they are not already selected.
Note: The Cary Employees
filter is not in the
Available items list
because you selected
Hide from user in the
Edit Filter dialog box. The test facility simulates
an end-user environment, so it has hidden the filter from you (the
end user).
-
Click
to populate the
Selected items list.
-
Click
Run Test to run a test query that uses the selected
items.
-
In the
Prompt Value Specification dialog box, add
SAM to the
Selected list box.
(
EDU should already be selected because it
is the default value.)
-
Click
OK. The
Results dialog box
is displayed with the results of the test query. The result set should
contain 41 rows. Even though you did not select the Cary Employees
filter for the test, the result set contains rows of Cary employees
only. The assigned prefilter eliminated the non-Cary information.