Assign a Prefilter

If you want a filter to prescreen and subset data before your end user's query is run, then assign the filter as a prefilter. SAS Information Map Studio supports two types of prefilters:
  • authorization-based prefilters, which apply to specific users and groups
  • general prefilters, which apply to all users
For the information map that you just created, you want to prefilter data so that the reports that are generated from the information map show information about employees who are located at the company's Cary location only.
To assign this general prefilter:
  1. If the Employee Statistics Sample information map is not open, select Filethen selectOpen from the SAS Information Map Studio menu bar.
  2. In the SAS Information Map Studio main window, select the Design tab.
  3. In the Information Map Contents pane, right-click Employee Statistics Sample, and then select Properties from the pop-up menu.
  4. In the Information Map Properties dialog box, select the General Prefilters tab.
  5. In the Selected filters pane, select EMPINFO.
  6. In the Available filters pane, select Cary Employees, and then click Insert.
    General Prefilters tab
    Note: Prompted filters cannot be used as prefilters, so the prompted filter that you created is not displayed.
  7. Now that this filter has been assigned as a general prefilter, you probably do not want end users to select it as a regular filter in their queries.
    To hide the filter from end users:
    1. Make sure that Cary Employees is still selected in the Available filters pane. Click Edit.
    2. On the Definition tab in the Edit Filter dialog box, select Hide from user.
      Edit Filter dialog box
    3. Click Update, and then click OK.
  8. Click OK to close the Information Map Properties dialog box.
  9. From the SAS Information Map Studio menu bar, select Filethen selectSave As and save the updated information map with the name Employee Statistics Sample with Advanced Features.