Aggregation tables can
be created using those tables that are supplied by the SAS IT Resource
Management Solution as a starting point. To create an aggregation
table with the
New Aggregation Table from Templates wizard, respond to the wizard's prompts.
-
On the
Specify
location page, you can specify the metadata location
where the newly created tables will be saved. You must specify a location
for the staged table that is within the IT data mart that is specified
in the
IT Data Mart field.
You can override the
default value for this field by clicking
Browse and selecting a path to the table from the
Select a
Location dialog box that displays the metadata directory
structure.
Note: The
IT data mart field displays the name of the IT data mart where the job is located.
It cannot be modified.
-
On the
Select
templates page, check the template tables that you want
to use to create aggregation tables. The
Total number
of selected template tables field is updated to reflect
the number of template tables that you selected.
For staged tables that
are designed to contain data that is already summarized to an hourly
interval, you cannot successfully select aggregations that attempt
to summarize the data to smaller intervals. When you specify an aggregation
table that summarizes data for a time period that is shorter than
the source table normally provides, a warning message is displayed
stating that the aging column cannot be created and the aggregation
table is not created. To avoid this situation, make sure that your
source table provides the appropriate level of summarized values for
the aggregation that you want to generate. For example, if you want
to specify an aggregation table such as FifteenMinAcctTcodeSy, make
sure that the source data (that is, the staged table) is summarized
no higher that 15 minutes and import the DATETIMEFIFTEENMINUTE computed
column into the staged table. (
For information about
importing a column into a staged table, see Modify a Staged Table.)Note: If the templates that you
select have a dependency on other templates, an information box is
displayed that lists the additional aggregations that will be created.
Click
Yes to accept this action and to continue.
Click
No to return to the
Select
Templates page.
-
If this aggregation
table is the first target table that is specified for this Aggregation
transformation, an additional page of the wizard opens. This page
prompts you for the physical target location and for information about
the SAS library where the data will be stored. When this page opens,
the following fields are already specified with default values. (However,
you can modify these fields.)
-
The
Name field contains the name of the library that will contain all aggregation
tables that are associated with the Aggregation transformation that
you are working with. This field can contain up to 60 characters and
should be unique within the IT data mart. A value is required in this
field.
-
The
Description field contains the information that describes the library. It can
contain no more than 200 characters. It is an optional field.
-
The
Server field contains the application server that you specified for the
IT data mart that you are working with. The default application server
is the SASITRM server. A value is required in this field.
-
The
Libref field contains the name that is temporarily associated with the
library. The libref for an aggregation library is a concatenation
of AGG and a random number (for example,
AGG27040). A value is required in this field.
-
The
Path specification field contains the location where the tables for this library are
to be stored. You must specify a location for the tables that is within
the IT data mart that is specified in the
IT Data Mart field.
Enter this field manually
or click
Browse to select a location from
the
Select a Directory dialog box that displays
the directory structure on the server's file system. A value is required
in this field.
-
The final page of the
wizard displays the details for the aggregation tables that you specified.
If the aggregation job that you specified adds more than 20 tables
to an existing job, a warning message is displayed. The message suggests
that you might want to remove some tables in order to experience better
performance. Click
Yes to continue to generate
the tables. Click
No to return to the Select
templates page, where you can change your selections. If you are satisfied
with your choices, click
Finish.
Click
OK to return to the process flow diagram.
Note: Some aggregation templates
require other aggregation tables to be created. If so, a dialog box
appears that notes the dependency and asking for confirmation before
proceeding.