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 and 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.
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.
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.
The Procedures by Synonym report shown in the following image lists each synonym and the procedures that use it.
The Columns by Procedure report shown in the following image lists each procedure and the synonyms and columns it uses.
The Procedures by Column report shown in the following image lists each column by synonym and by the procedures that use it.
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.
The Impact Analysis report opens in the workspace.
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.
The Impact Analysis report opens in the workspace.
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 |