Impact Analysis Reports on Synonyms, Procedures and Columns

How to:

Reference:

Note: Both flows and stored procedures are referred to generically as procedures.

Impact Analysis Reports on procedures, synonyms, and columns provide information on the flows/stored procedures available on a particular server, and the synonyms and columns they use. They allow you to evaluate changes before they are made by showing which components will be affected. Impact Analysis Reports provide quick analysis of synonym and column usage, and allow you to get procedure information without opening them individually. These reports are drill-down reports, which allow you to double-click entries to open the procedures in the workspace. Impact Analysis reports are also available for individual synonyms and columns.

There are six types of reports:

Note: Enterprise reports do not appear if you do not have any subservers.


Top of page

x
Procedure: How to Run an Impact Analysis Report on Synonyms, Procedures, and Columns

Note: Both flows and stored procedures are referred to generically as procedures.

Impact Analysis reports provide information on the procedures, synonyms, and columns available on a particular server. They allow you to evaluate changes before they are made by showing which components will be affected. The reports can be sorted by procedure, by synonym, or by column. The results can be exported to Microsoft Excel, copied as text, or printed. For details, see Working With a Report.

  1. In the navigation pane, right-click Application Directories or a specific application directory and select Impact Analysis, which will have menu of options, as shown in the following image.

    Impact analysis menu

  2. From the menu, select Synonyms by Procedure, Procedures by Synonym, Columns by Procedure, Procedures by Column, Synonyms by Procedure for Enterprise, Procedures by Synonym for Enterprise, or a Summary or Detailed Flow Report from the Flow Report context menu.

    The report opens in the workspace.

These reports include the procedure and synonym directories, columns and column types, synonym usage (source or target), adapter type, table name, description, and prior to load and load type options. These reports are drill-down reports, which allow you to double-click the procedure name entries to open the flows or stored procedures in the workspace.

The Synonyms by Procedure report shown in the following image lists each procedure and the synonyms it uses.

Synonyms by Procedure Report

The Procedures by Synonym report shown in the following image lists each synonym and the procedures that use it.

Procedures by Synonym Report

The Columns by Procedure report shown in the following image lists each procedure and the synonyms and columns it uses.

Columns by Procedure Report

The Procedures by Column report shown in the following image lists each column by synonym and by the procedures that use it.

Procedures by Column Report


Top of page

x
Procedure: How to Run an Impact Analysis Report on a Particular Synonym

An Impact Analysis report on a particular synonym provides information on the procedures and reports that use it and how it is used. It allows you to evaluate changes to synonyms before they are made by showing which components will be affected. The results can be exported to Microsoft Excel, copied as text, or printed.

These reports are drill-down reports, which allow you to double-click entries to open procedures in the workspace to make the necessary changes.

  1. Right-click a synonym in the navigation pane and select Impact Analysis.

    The Impact Analysis report opens in the workspace.

  2. Double-click a procedure name to open it in the workspace.

Top of page

x
Procedure: How to Run an Impact Analysis Report on a Particular Column

An Impact Analysis report on a particular column provides information on the procedures and reports that use it and how it is used. It allows you to evaluate changes to the column before they are made by showing which components will be affected. The results can be exported to Microsoft Excel, copied as text, or printed.

These reports are drill-down reports, which allow you to double-click entries to open procedures in the workspace to make the necessary changes.

  1. Double-click a synonym in the navigation pane to open it in the Synonym Editor.
  2. Right-click a column on the left side of the Synonym Editor and select Impact Analysis, as shown in the following image.

    Impact analysis option

    The Impact Analysis report opens in the workspace.

  3. Double-click a procedure name to open it in the workspace.

Top of page

x
Reference: Synonym, Data Flow, and Column Impact Analysis Report Columns

Synonym, Procedure, and Column reports provide the information listed and described in the following table:

Column

Format

Function

Found In

Alpha 32

Flow or stored procedure name.

Found In Application

Alpha 18

Flow or stored procedure application directory.

Found In Type

Indicates if the object was found in a stored procedure or flow.

Synonym

Alpha 64

Synonym name.

Synonym App

Alpha 64

Synonym application directory.

Note: This value will only appear if you are using application directories.

Usage

Alpha 36

How the synonym or column is used, for example, the source, target, or transformation.

Line

Alpha 8

The line number where the item appears.

Adapter

Alpha 64

Synonym format.

Table Name or Dataset

Alpha 133

Data target table name.

Synonym Remarks

Alpha 78

Synonym description.

Prior to Load

Alpha 13

Prior to load option for targets.

Load Type

Alpha 35

Load type for targets.

Procedure Description

Alpha 150

Flow or stored procedure description.

Column

Alpha 66

Column name.

Used In

Alpha 100

The expression that uses a particular column.

Identifier

Alpha 66

The expression unique identifier.


iWay Software