Specifying a Data Source Location

SAS IT Resource Management provides flexibility and portability of report jobs, Performance Report transformations, and report definitions by enabling you to specify the location of the source data for a report in various ways.

Here are the ways that you can specify the data source location and how the report job uses these paths to find the data source:

In the Performance Report transformation and ITRM Report Definition task, do not specify a data path.

A data source location might not be specified within the Performance Report transformation or report definition from an ITRM Report Definition task. In that case, the report job looks for the data source in the same IT data mart folder as the report job. This is the default and recommended scenario.

Tip
The Adapter Setup and Add Domain Category wizards store data sources (or information maps) in the same folder as their corresponding report jobs. Thus, a Performance Report transformation that the wizard creates does not include values in the Data Source Folder column. In addition, the report definitions that the wizard uses do not include data path locations. For consistency and portability of your reporting components, save your information maps in the same folder as their corresponding report jobs. In addition, do not specify a data source location in your Performance Report transformations or report definitions.
In a Performance Report transformation, specify a data path by using the Data Source Folder field for a report definition. For more information, see Add a Performance Report Transformation to a Report Job.

If you enter a data path in this field, then the report job uses this path, regardless of whether a data source location is specified in the report definition from the ITRM Report Definition task. If this field is blank, then the report job checks the corresponding report definition to identify a data source location.

The default value is blank.
In an ITRM Report Definition task, specify a data path by selecting Yes for the option Include data path in report definition. For more information, see Create Report Definitions Using the ITRM Report Definition Task.

If you select Yes to include the data path in the report definition, then the path is hard coded with the report definition. In addition, the data path appears in the Properties of report definition box of the Performance Report transformation. The report job uses this path, unless the corresponding Performance Report transformation includes a value for the Data Source Folder that overrides the report definition.

By default, the ITRM Report Definition task does not specify a data path in the report definition that it creates.