Maintaining Data Warehouses and Subjects

Overview

After you have created a Warehouse Environment, you can define one or more Data Warehouses within it. In SAS/Warehouse Administrator, a Data Warehouse is a metadata record that specifies the SAS library _DWMD. The _DWMD library is the metadata repository for most of the groups and data stores in a data warehouse or a data mart at your site.

To create a Data Warehouse:

Open the appropriate Warehouse Environment in the Explorer.
Define the properties of the Data Warehouse.

After you have created a Data Warehouse, you can define one or more Subjects within it. A Subject is a grouping element for data related to one topic within a Data Warehouse. For example, a Data Warehouse might have a Subject called Products (information related to products) or Sales (information related to sales). Each Subject can be composed of a number of different data collections: detail data, summary data, charts, reports, and graphs.

To create a Subject:

Open the appropriate Warehouse Environment in the Explorer.
Locate the Data Warehouse in which the Subject will be added.
Add the Subject to the Data Warehouse.
Update the default properties of the Subject.

Note: The basic steps for maintaining Data Warehouses and Subjects are described in the online Help. To display the relevant online Help, in the SAS System Help contents, select Help on SAS Software Products Using SAS/Warehouse Administrator Software Defining Data Warehouses and Subjects In addition, you can display Help for most SAS/Warehouse Administrator windows by selecting the Help button on the window. [cautionend]

Top of Page