Maintaining Detail Logical Tables and Detail Tables

Example: Creating a Detail Logical Table as a Grouping Element for Detail Tables

The simplest use of a Detail Logical Table is to create it as a grouping element for Detail Tables. Note that when a Detail Logical Table is used as a grouping element, it does not have an associated Process Editor Job. However, each Detail Table grouped by the Detail Logical Table would have a Process Editor Job.

Note: The following explanations describe the metadata and methods used to achieve the desired results; it is assumed that the appropriate Data Warehouse Environment, Data Warehouse, and Subject exist. [cautionend]

Define Detail Logical Table Properties

In the SAS/Warehouse Administrator Explorer, position the cursor on the Subject, for example Subject, click the right mouse button, select Add Item, and then Detail Logical Table. In the Explorer window, a Detail Logical Table is added under the Subject as follows:

[untitled graphic]

To update the default metadata for the Detail Logical Table, position the cursor on its icon, click the right mouse button, and select Properties. The Detail Logical Table Properties window displays for you to enter the appropriate information.

General Tab

specifies the table name Group Detail Logical Table, a description, an owner, and an administrator.

[untitled graphic]

Tables Tab

specifies the Detail Tables that are members of the Detail Logical Table, which do not exist yet.

[untitled graphic]

The next section describes how to create a Detail Table to add to the Detail Logical Table.

Top of Page