Maintaining Information Marts

Overview

SAS/Warehouse Administrator provides the ability to create an information mart, which is an application (or the output from an application) that runs against warehouse data. An information mart can provide answers to business questions and can also be used to document any portion of the warehouse or its implementation.

In SAS/Warehouse Administrator, the following objects are provided to create an information mart:

Information Mart (or InfoMart)	is a simple grouping element that allows you to organize Information Mart Items and Information Mart Files. Unlike most objects in SAS/Warehouse Administrator, Information Marts are used to display information rather than store it. You can add an Information Mart to a Subject, a Data Group, or an ODD Group.
Information Mart Item (or InfoMart Item)	is a metadata record that specifies a routine, which generates output from data stores in a Data Warehouse. The output is usually a SAS chart, report, graph, or query result. For example, an Information Mart Item could display a chart that summarizes sales information from a detail data store. An Information Mart Item can be added only to an Information Mart.
Information Mart File (or InfoMart File)	is a metadata record that specifies a file type other than SAS that is registered in a Warehouse Environment. The file can be a spreadsheet, an HTML report, or any file that can be opened by an external application. Information Mart File metadata describes the location of an external file and the technique for opening that file. For example, an Information Mart File could open a spreadsheet that contains information useful to the person managing a Warehouse Environment. An Information Mart File can be added only to an Information Mart.

In general, to maintain Information Marts:

Define the properties of the Information Mart.
Define the properties of Information Mart Item(s) and Information Mart File(s).
For an Information Mart Item, define a Process Editor Job that includes the data preparation processes, which prepare the data to be loaded into the data store(s), and the Load Step, which defines the steps to load the data store(s).
For an Information Mart Item, execute the Job.
Verify that the data store is loaded; that is, check logs, use the data utilities, and so on.

Note: The basic steps for creating an Information Mart and related objects are described in the online Help. To display the relevant online Help, in the SAS System Help contents, select Help on SAS Software Products, then select Using SAS/Warehouse Administrator Software. Finally, select Defining Information Marts. In addition, you can display Help for most SAS/Warehouse Administrator windows by clicking Help on the window. [cautionend]

Top of Page