Introduction
Data flows logically in a specified ordered manner to form a data warehouse.
The objects which comprise the data warehouse include reports, programs and
data. Proper management of the dependencies among these objects will allow for
effective refreshing of the data warehouse and tracking of the status information among
the objects. The tools to manage the dependencies are found by clicking on the dependencies
icon in the study design area. An example of the dependency design diagram is
shown here.
The following are functions that are available to manage the dependencies:
- Adding a new dependent object to an existing one
- Adding a new dependency root
- Navigating among diagrams
- Modifying properties of existing objects
- Deleting dependency objects
Adding Dependent Objects
A dependency diagram is created by adding new dependent object(s) to existing
objects. Objects which can be added include:
For example, the following demog data is dependent upon the program a_ptinfo.sas,
since the a_ptinfo.sas program creates the demog dataset.
The diagram may start as shown here:
To add the dependent program, left mouse click on the demog data object and a
pop up menu will appear. The Add Program item is selected as shown here:
A list of programs will then be displayed. Note that multiple items can be
selected from the list if this is desired.
Click on the OK button and the dependency diagram is refreshed.
Adding New Root
Root objects are managed similar to other objects. However, the root object
is intended to group a set of dependent objects together for ease of management.
Since there is only one root object per diagram, a new root object creates a new
diagram. This is accomplished by clicking on the New Root Object button.
When this is done, an empty diagram is created as shown here.
Navigating Diagrams
The current root object is dislayed at the top of all dependency diagrams.
A pull down menu is available for easy navigation between diagrams. To navigate to
another diagram, just select the current root object from the pull down menu.
Modify Properties of Objects
All objects contain attributes such as name and description. To modify
these properties, left mouse click on the object and select the Properties...
menu item. In the case of the root object, the only attribute is the root name.
In this case, type in the new name of the object and click OK.
Deleting Dependency Objects
All objects appearing on the dependency diagram can be removed. This is
accomplished by left mouse clicking on the object which needs to be removed. Then
select Delete Current Object from the menu. Note that all
dependent objects to the current deleted object will also be removed. The removal of
the dependency objects will only apply to the current diagram and does not permanently
affect the underlying objects.
|
