Use the Show Related notebook to display first-level subordinate dependencies for the currently selected object. The Show Related notebook shows relationships that cannot be easily seen in the tree view or by using the Locate function.
You can display related objects from an object instance or from the Show Related notebook itself.
You can compare relationships between multiple target objects and their related objects by opening the Show Related notebook multiple times from the Data Warehouse Center object tree.
You can perform other actions on an object displayed in the Show Related notebook by right-clicking on the object and selecting an action from the pop-up menu.
To view second-level dependencies, you must select Show Related for each first-level dependency object that exists. For example, imagine that you select Show Related for a target table, Table 1. On the Steps Populated page of the Show Related notebook for Table 1, you see Step A because it has a first-level dependency on Table 1. If another table, Table 2, receives data from Step A, it would have a first-level dependency on Step A and a second-level dependency on Table 1. However, Table 2 is not listed in the Show Related notebook for Step A. You must right-click on the Step A object in the notebook and click Show Related from the pop-up menu to see the Table 2 dependency on Step A.
To show related objects:
Open the Show Related notebook. View the objects. Each type of object related to the target object is displayed on a separate page of the Show Related notebook.
Click on the tabs to display the different objects that are related to the original object.
Optional: Right-click on an object in the Related objects list and click Show Related from the pop-up menu. The list changes to show the objects related to your current selection, and the previous target object is added to the list.
Optional: Click the arrow next to the currently selected object to display a list of previously selected target objects and select one. The Related objects list changes to show the objects that are related to the current target object.
Click on Close to close the Show Related notebook and return to the Data Warehouse Center.
The Show Related notebook pages vary according to the object that you select. Select an object below to see information about the types of objects that can be related to it.