How to Use the Exception Analysis Feature

The exception analysis feature is specified within a job that contains an Exception transformation. The Exception transformation can be generated in two ways:

automatically, as a transformation within a job that is created by the Adapter Setup wizard or the Add Domain Category wizard.

If the wizard is creating jobs for an adapter and domain category for which exception definitions have been created, then an exception job is also created. The exception job uses a staged table as input and generates a target exception table. Exception jobs are not created by the Adapter Setup wizard for aggregation tables.

You can review the specifications of the exception definition by navigating to FoldersShared DataSAS IT Resource ManagementException Definitions. Select the definition and review the descriptive information that is displayed at the bottom of the window.
manually, as a transformation within a job that you create.

To do so, perform the following tasks:
1. Create a new job.
2. Add an Exception transformation to the job.
3. Determine what input source table you want to use and add it as a source table to the transformation. (The source table can be any SAS table.)
  
  Note: Column names in the input table that have a double-underscore (__) prefix might conflict with temporary variables that are used in Exception transformation processing.
4. Designate what data should be kept for any detected exceptional conditions by adding target (output) tables.
5. Determine what exceptional conditions you want to detect.
  
  You can select from a supplied set of predefined exception definitions that are located at FoldersShared DataSAS IT Resource ManagementException Definitions.
  
  You can specify the exceptional conditions that you want to detect by using the New Exception Definition wizard. This wizard can be accessed from the Exception transformation.
6. Specify whether exception reports should be generated.
  
  Specify whether you want to trigger alerts.
7. Run the job that contains the Exception transformation.
8. Review the reports and alerts that might be triggered by the job. Take the appropriate actions.

For more information, see About the Exception Transformation.