Preparing to Create an Aggregation Table

Set Up the Aggregation Transformation in the Process Flow Diagram

To create an aggregation table, you must first set up the Aggregation transformation in a job and then invoke one of the aggregation wizards. To set up the necessary Aggregation transformation, perform the following steps:

Locate the job that you want to contain this Aggregation transformation. From the IT Data Marts tree, navigate to the IT data mart and folder that contains the job that you want to use. Double-click the job to open it on the Diagram tab of the Job Editor window.

If you want to create a new job, see Jobs That Process IT Data.
Navigate to the Transformations tree and expand ITRM Transformations.
Drag and drop the Aggregation transformation onto the process flow diagram.

Note: A job can contain multiple Aggregation transformations.
Drag and drop a source table onto the process flow diagram and using the cursor, connect the table to the left side of the aggregation image.

Note: The source table is usually a staged table that was created by a SAS IT Resource Management staging transformation, but it can be any SAS table.
Right-click the aggregation image and, from the drop-down menu that is displayed, select Add Aggregation Table.
Select the type of aggregation table that you want to create. (If you click Cancel on any page of an aggregation wizard, a confirmation dialog box is displayed. If you do not want to cancel, click No.)
- Select Simple Aggregation Table to invoke the Simple Aggregation Table wizard. For information about using this wizard, see Creating an Aggregation Table with the Simple Aggregation Table Wizard.
- Select Summarized Aggregation Table to invoke the Summarized Aggregation Table wizard. For information about using this wizard, see Creating Aggregation Tables with the Summarized Aggregation Table Wizard.
- Select Aggregations through Template to invoke the Aggregations through Template wizard. This wizard enables you to choose one of the following template sources:
  
  From Supplied Template
  
  From User Defined Template
  
  For information about using this wizard, see Creating Aggregation Tables with the Aggregation through the Template Wizard.
Note: You can create multiple summarized aggregation tables. The aggregation wizard provides a unique suffix for each table that is created.