Maintaining Information Marts

Example: Creating an Information Mart Item

This example creates an Information Mart Item that displays a percentage chart of sale promotion types generated from the ODD Promotions.

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, Subject, Information Mart, and ODD already exist. [cautionend]

Define Information Mart Item Properties

In the SAS/Warehouse Administrator Explorer, position the cursor on the Information Mart (for example, InfoMart for Toy Sales), click the right mouse button, select Add Item, and then Information Mart Item. In the Explorer window, a new Information Mart Item is added under the Information Mart as follows:

[untitled graphic]

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

General Tab

specifies the item name Percent of Promotion Types, a description, an owner, and an administrator.

[untitled graphic]

Data Location Tab

specifies where the output is stored. An Information Mart Item is stored as a SAS catalog entry. The following types are supported: SOURCE, FRAME, PROGRAM, GRSEG, LOG, OUTPUT, QUERY, and REPORT.

[untitled graphic]

Open Code Tab

specifies the source code used to view the item stored in the SAS catalog entry listed in the Data Location tab.

[untitled graphic]

Note: To use the default code shown in this screen, you must have SAS/AF software licensed. Other examples of code that you could specify include the WBROWSE command or, for SOURCE catalog entries, you could specify

dm "notepad &loc";

Define Process Editor Job

In the Process Editor Job, the Information Mart Item Percent of Promotion Types is specified as the output target and the ODD Promotions is specified as the input source. The following Process Editor window displays the Process Flow for the Job:

[untitled graphic]

The Load process defined in the Job is summarized next. Note that there is not a Mapping process. The Information Mart Item is generated by running source code against the specified data.

Load Step Process

The source code is user written and stored as a SAS catalog entry.

[untitled graphic]

To enter the source code or to display it, click Edit. The user-written source code is as follows:

[untitled graphic]

For more information about Process Editor Jobs, see Maintaining Jobs. For more information about processes, see Maintaining Processes.

Display Output

First, you must execute the Job, which executes the user-written code specified in the Load process, generates the output, and stores it in the specified catalog entry. Then, to display the output, open the Info Mart Item Properties window and click Open.

[untitled graphic]

Top of Page