Working with Report Jobs :: SAS(R) IT Resource Management 3.5: Reporting Guide

Create a Report Job

The Adapter Setup and the Add Domain Category wizards create report jobs for several adapters and domain categories. You can view these supplied reports here: Samples of Supplied Reports. These reports are organized by adapter and domain category.

However, you might need to create or modify your own report job. For example, you might want to create batch reports for a domain category for which SAS IT Resource Management does not already provide reports.

To create a report job, you must first create a job and then add a Performance Report transformation to that job. To do so, perform the following steps:

In the SAS IT Resource Management client, open or create a job. If you want to work with an existing job, double-click on that job to open it on the Diagram tab of the Job Editor window of SAS IT Resource Management.

If you need to create a new job, you can invoke the New Object wizard from the File menu of SAS IT Resource Management. For information about how to perform this task, see the “Create a Job” topic in the SAS IT Resource Management 3.5: Administrator’s Guide.

The new job opens on the Diagram tab of the Job Editor window.
Navigate to the SAS IT Resource Management folder of the Transformations tree of SAS IT Resource Management.
Drag the Performance Report transformation onto the job in the Diagram tab of the Job Editor window.

Note: A Performance Report transformation does not have an input or output object that is displayed in the process flow diagram of a report job. Thus, a report job can include one Performance Report transformation as the only object in the process flow diagram of the job and still be valid.
Modify the Performance Report transformation parameters as needed to meet the reporting needs of your organization. For more information, see Add a Performance Report Transformation to a Report Job. Then save the job.
Deploy and run the report job. For more information, see Deploying and Running Report Jobs.

Modify a Report Job

To edit an existing report job, perform the following steps:

In the IT Data Marts tree of SAS IT Resource Management, double-click the report job that you want to edit.
Edit the report job.
To Edit the Properties of the Report Job
1. Right-click the report job in the IT Data Marts tree.
2. To rename the report job, select Rename.
3. To view and modify the properties of the report job, select Properties. For more information about the properties for a report job, see the Help for SAS IT Resource Management.
4. Click OK. Save the job.
To Edit the Properties of a Performance Report Transformation in the Report Job
1. Right-click the Performance Report transformation in the process flow diagram and select Properties. A Properties dialog box is displayed and enables you to modify the various parameters that are specified for the Performance Report transformation and the code that it generates. For more information, see Edit a Performance Report Transformation.
2. Click OK. Save the job.
For more information about the specific parameters that are available for configuration in the Performance Report transformation, see the detailed steps in Add a Performance Report Transformation to a Report Job.
Deploy and run the report job. For more information, see Deploying and Running Report Jobs.

Copy a Report Job

To copy a report job, perform the following steps:

Navigate to the location of the job in the IT Data Marts tree.
Right-click the job.
Select Copy.
Right-click the folder where you want the copy of the job to reside.
Select Paste. A copy of the report job is saved in the folder and is assigned the default name Copy of <original job name>.
Double-click the new job to open it in the Diagram tab of the Job Editor.
Right-click the Performance Report transformation in the process flow and select the Server tab.
Specify the name and location of the SAS Content Server for the Performance Report transformation.
Click OK. Save the job.

Delete a Report Job

To delete a report job, perform the following steps:

Navigate to the location of the job in the IT Data Marts tree.
Right-click the job.
From the menu that is displayed, select Delete.
In the confirmation box, click Yes to delete the job.

If you delete a report job that has already run, then the reports that the job created remain in the SAS Content Server until an administrator deletes them manually. The only way that a report is programmatically deleted from the SAS Content Server is when the report has expired and its report job is rerun to remove and replace the report.

Note: If you delete a report job in an IT data mart but the report job has already been deployed, then the deployed job can still be run in batch.

Deploying and Running Report Jobs

About Deploying and Running Report Jobs

After you create or modify a report job, you can deploy and run the job to purge expired reports, and create new reports in the SAS Content Server where ITRM Report Center can access them. Report jobs are the last step in the batch reporting process flow. Therefore, they rely on the successful completion of all the jobs and components that precede it in the data extraction, transformation, loading, and reporting process.

Deploying a job enables you to execute the job outside of SAS IT Resource Management, such as when scheduling a job to run at a specified time. SAS IT Resource Management enables you to deploy as well as run jobs. For more information about how to deploy and run jobs, see the Chapter 14, “Jobs,” in the SAS IT Resource Management 3.5: Administrator’s Guide.

Deploy and Run Report Jobs That the Adapter Setup or Add Domain Category Wizard Creates

The Adapter Setup and the Add Domain Category wizards create a set of jobs that compartmentalize each step of the extract, transform, load, and reporting process for IT data. These jobs depend on one another to process the raw data for reporting. For example, aggregation jobs include aggregations that rely on the staged tables that are generated when the staging job is run. As a result, each job should be run only after the jobs that it depends on have been run. The following list shows the types of jobs that the Adapter Setup and the Add Domain Category wizards create and the dependencies of each. Each job type in the list is dependent on the job type that precedes it.

staging job
aggregation job
information map job
reporting job
exception job

Note: An exception analysis job is created by the Adapter Setup wizard or the Add Domain Category wizard for each adapter for which exception definitions are supplied for the stage tables. For information about the Exception transformation, see Chapter 9, “Exception Analysis Processing,” in the SAS IT Resource Management 3.5: Administrator’s Guide.

For more information about the Adapter Setup and Add Domain Category wizards, see Working with the Adapter Setup and Add Domain Catgegory Wizards.

Deploy and Run Your Own Report Jobs

You can create, deploy, and run your own report jobs manually, without using the Adapter Setup or Add Domain Category wizard. However, like the report jobs that these wizards create, your report jobs must also rely on other processing components that extract, transform, and load your IT data. For consistency and efficiency, use the same naming conventions and job structure that these wizards use when you create your own jobs and components for this process. For information about what the Adapter Setup or Add Domain Category wizards create, see the Chapter 10, “Adapter Setup Wizard,” and Chapter 11, “Add Domain Category Wizard,” in the SAS IT Resource Management 3.5: Administrator’s Guide.

After you confirm that all of the extract, transform, and load components for your report job are prepared and successfully executed, you can deploy and run your report job.