Information Map Objects That Are Generated by the Adapter Setup Wizard and the Add Domain Category Wizard :: SAS(R) IT Resource Management 3.7: Administrator's Guide

What Information Map Objects Do the Adapter Setup and the Add Domain Category Wizards Generate?

The Adapter Setup and the Add Domain Category wizards create jobs that contain Information Map transformations for many of the adapters that SAS IT Resource Management supports. Using these wizards is the most convenient way to create Information Map transformations and information maps for selected adapters.

When the Adapter Setup and Add Domain Category wizards run, they create objects that pertain to the staging and aggregating of data. In the case of most supported adapters, these wizards create the objects that pertain to the generation of information maps, such as the following:

an information map job.
Information Map transformations that are contained in the information map job. For most supported adapters, an Information Map transformation is created for each aggregation table.
information maps that are generated when their corresponding Information Map transformations are run.

Note: To see the results of the job in the hierarchy view, right-click in the hierarchy view and select Refresh.

When generated by the Adapter Setup wizard or Add Domain Category wizard, information map objects are defined and created according to predetermined conventions for naming, storage, and filter creation. These conventions enable you to effectively manage and locate the information map objects that the wizards create.

For more information about the Adapter Setup wizard, see About the Adapter Setup Wizard. For more information about the Add Domain Category wizard, see About the Add Domain Category Wizard.

How the Adapter Setup Wizard Names Information Map Objects

For consistency and efficient identification, name your Information Map transformations and information maps using the same conventions as the Adapter Setup wizard.

For most supported adapters, the Adapter Setup and Add Domain Category wizards automatically create jobs that contain Information Map transformations. The source tables for these transformations are aggregation tables, which are also created by those wizards. The transformations are given the same names as their associated source aggregation tables—for example, <level > (such as week, day, month, and so on) + <measurement category > (such as cache, memory, server, network, and so on). The following name is an example of this naming convention: DaySystem.

The Information Map transformations also create information maps with the same name as the source aggregation tables. As a result, the aggregation tables, Information Map transformations, and resulting information maps for an information map job created by the Adapter Setup or Add Domain Category wizard all have the same name. This naming technique helps you identify and associate each object easily.

Note: The name of the information map cannot contain any of the following characters: * ? " ' | \ / [ ] $ & > < ( ) { } : ; ` ~ % ^ @ # ! In addition, the name cannot contain a newline or tab character.

Where the Adapter Setup or Add Domain Category Wizard Stores Information Map Objects

By default, the Adapter Setup and the Add Domain Category wizards store information maps in the same location as the job that contains the corresponding Information Map transformation. However, you can change where the information map is stored by revising the Information map path field. That field is located on the Information Map Parameters tab of the Properties dialog box of the Information Map transformation.

For example, when the Network Information Map job was run, the resulting information maps were created and stored in the default location. That is, they were stored in a subfolder named for the measurement category in the Network subfolder of the Domain Categories folder of the IT data mart. The following display shows the tree structure of these objects. The Network folder contains the aggregation tables, the information maps, the library, and the aggregation and information map jobs that were created by the Adapter Setup wizard.

Network Domain Category

What Information Map Filters Does the Adapter Setup or Add Domain Category Wizard Create?

When the Adapter Setup or Add Domain Category wizard creates Information Map transformations, it also creates filters. The wizard automatically provides two categories of filters for columns in the aggregation tables that they are associated with.

It provides one filter for each ranked statistic column.
It provides one or more filters for each ranked date class column.

These filters are specified in the Information Map transformations and propagated to the information maps that are created when the job is run. The filters are then available in the information maps for analysis and reporting when you use SAS Enterprise Guide and SAS Web Report Studio.

For more information about working with information map filters, see Working with Information Map Filters.

How the Adapter Setup or Add Domain Category Wizard Names Information Map Filters

The Adapter Setup and Add Domain Category wizards use specific conventions for naming and describing the information map filters that it provides. These conventions use best practices for naming and describing filters in a way that is concise, meaningful, and effective for use with other SAS solutions. For best results, use the following conventions that these wizards use when naming and describing the information map filters that you create:

Provide each filter with a unique name within an information map. No two filters in an information map can have the same name. However, filters with the same name can be in multiple information maps.
The information map library engine that is used by SAS Enterprise Guide to access information maps truncates filter names that are longer than 32 characters but ensures that they are unique.
Include the ranked column name and the corresponding filter value in the description for the filter. The Adapter Setup and Add Domain Category wizards include the ranked column name and the corresponding filter value in the description for the filters that it provides. For example, if the CacheReadHitPctMinAscRank column is filtered in ascending order from one to ten (including one and ten), then the description for that filter is “CacheReadHitPctMinAscRank 1–10.” For best results, use this convention to describe the information map filters that you create so that your information map filters are consistently identifiable.