This report lists the columns derived from the selected objects.

Objects Included

The following WhereScape RED object types are included in this report:

• Load Tables
• Stage Tables
• Dimension Tables and Views
• Fact Tables
• Aggregate Tables
• Exports
• Hubs, Satellites and Links

Parameters

• Groups
• Projects
• Table
• Column

Results

If you left the Exclude Intermediate Steps checkbox unchecked then the results screen is as follows, showing the impacted tables for the selected tables:

If however, you selected Exclude Intermediate Steps then the results screen is as follows, showing only the final impacted table for the selected tables:

The results of this report are displayed as a list of impacted tables and columns, the order of the result set determining the immediate impact. The report includes the following columns:

• Tables (the names of selected tables)
• Columns (the names of selected columns)
• Impact Tables
• Impact Columns

The result set is not sortable, as the order of the result set determines the immediate lineage.

Sending Results to Microsoft Excel

Right-click the result set and click Output to File to send the results of this report to Microsoft Excel.