Show Impact of Change is an Impact Manager module option that displays the tables, columns, and joins that are used in documents on the Query Panel. Selected values display the effects on the documents of changes to selected items.
Note: | The example uses Microsoft Access database software and the Sample Database. The Interactive Reporting database connection must be configured, see Connecting Interactive Reports. |
To use Show Impact of Change:
Select Navigate, then Impact Manager, and then Show Impact of Change.
The Query Panel of the Show Impact of Change interactive report is displayed.
From the lists, select items, and click
to apply the selections.For example, if MSAccess and the Sample Database are used, from Rdbms Table Name, select PCW_CUSTOMERS and PCW_SALES. Selections are displayed in Currently Selected Query Limits.
The items selected in the Query Panel are displayed. For example, the table tabs in Document with RDBMS tables selected display PCW_CUSTOMERS and PCW_SALES.
to process the query.The Show Impact of Change interactive report contains information that helps identify what to do in anticipation of a change to a schema:
Documents with RDBMS tables selected—Impacted documents that use the selected tables and columns
RDBMS/Topic column mappings—Interactive Reporting document topics or items mapped to RDBMS tables or columns
Topic/RDBMS column mappings—Reverse map of RDBMS tables or columns to Interactive Reporting document topics or items
Data Models with topics in common—Common data models where impacted tables or columns are used (For example, how many Interactive Reporting documents are updated with one replacement data model)
RDBMS table usage details—Documents and sections in which tables and columns are used
Custom request items—Custom SQL in request items that Update Data Models, JavaScript Update, or a Custom Update may impact
Custom query limits—Custom SQL in filter items that Update Data Models, JavaScript Update, or a Custom Update may impact