Test the Cascading Prompts

To ensure that the updated filter is working as expected, test the information map again:
  1. On the toolbar, click Run a test query.
  2. In the Test the Information Map dialog box, select Department, Average Salary, and Which department? from the Available items list.
  3. Click Add to populate the Selected items list.
  4. Click Run Test to run a test query that uses the selected items.
  5. In the Prompt Value Specification dialog box, the location prompt is populated with the default value of Cary. The department prompt is also populated with departments that are in the Cary location. Change the value of the Please select a location drop-down list to Austin. As soon as you select the new location, the available values for the department prompt will change to the departments at the Austin location only.
  6. Select TX0 and TXR in the Available list, and then click Add.
    Prompt Value Specification dialog box
  7. Click OK. The Results dialog box is displayed with the results of the test query. The result set should contain two rows.
    Test query results
Copyright © SAS Institute Inc. All rights reserved.