Impact Analysis Report

In this section:

The Impact Analysis Report provides information on the affects of column changes.

To access the Impact Analysis report in the Web Console, click Resource Management on the toolbar and expand the Reports and Resource Analyzer folders. Expand the Impact Analysis folder. Right-click the available report, and select Run from the context menu.

The available report is the Change Impact for Column Report. It provides which procedures and end users will be affected by changes to column names and format. This report supplies you with information that can help you understand the rippling effects of data schema changes.

Note: In the tables of drill-down links, terms shown in italic represent placeholders, indicating the term can have different values, depending on the selections for that report.


Top of page

x
Change Impact for Column Report

It is very useful to determine in advance which users and applications will be most affected by impending data source schema changes. The Change Impact for Column reports determine how data-source modifications affect users and their applications.

Right-click Change Impact for Column and select Run. Select the column for which you want to examine information under the Column name drop-down menu and click View Report. Any use of a column with that name in any monitored table is reported.

The report window opens, as shown in the following image. This report summarizes the procedures used to access the specified column.

Change Impact for Column Report

This report has two hyperlinks that allow you to drill down to additional reports summarized in the following table.

Drill-Down Hyperlink: Click...

Report Generated

Description

A value under the Procedure Name column.

Requests from Procedure Procedure Name

Shows a variety of information, including date and time, user, CPU seconds, elapsed time, I/Os, and rows returned, about the requests made with the specified procedure. Also allows you to drill down further to see the actual request syntax.

A value under the Data Source column.

Column Level for Data Source Data Source

Shows usage for the columns for the specified data source, including whether they were used with functions, relations, selects, sorts, groups, or never used. Also allows you to drill down to see more information about when the columns were used.


WebFOCUS