Replace Resources

An information map references many external resources such as servers, libraries, tables, and cubes. Over time, the metadata that is registered for an external resource might be changed (for example, deleted or moved) so that the information map can no longer access or locate the resource. Or, you might need to reference a different resource (for example, your information map references the resources in a development environment and must now reference the resources in a production environment). The Resource Replacement dialog box provides a way for you to repair or update references to resources without re-creating the information map.
In this scenario, your administrator has used SAS Management Console to rename the EMPINFO table to EMPLOYEE. When you reopen the Employee Statistics Sample information map, you see that the EMPINFO data source is marked with a red x. The data source is trying to find the table named EMPINFO, but that table no longer exists because it has been renamed.
Selected Resources pane with data source error
To replace the EMPINFO table with the EMPLOYEE table for the EMPINFO data source:
  1. From the menu bar, select Toolsthen selectResource Replacement.
  2. In the Resource Replacement dialog box, select the Tables tab.
    Tables tab with unresolved resource
    Note: The SALARY data source is not displayed because it uses a resolved table. To display SALARY, clear the Display only unresolved resources check box.
  3. For the EMPINFO data source, click the cell in the Replacement Table column of the resources table.
  4. From the drop-down list, select EMPLOYEE. After you make the selection, the resources table is cleared because all resources were resolved when you replaced EMPINFO with EMPLOYEE.
    Tables tab with no unresolved resources
  5. Click OK. In the Selected Resources pane, the EMPINFO data source is no longer marked with a red x.
    Selected Resources pane with no errors
    Note: The resource replacement feature replaces the table that is associated with the data source, but it does not change the name of the data source. So, the Selected Resources pane still displays EMPINFO and not EMPLOYEE. If you want to update the name of the data source, you can use the Rename option in the pop-up menu for the data source.
  6. Save the information map.
Copyright © SAS Institute Inc. All rights reserved.