This report lists the origins of 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 check box unchecked, then the results screen is as follows, showing the line of origins for the selected tables:

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

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

• Tables (the name of a selected table)
• Columns (the name of a selected column)
• Source Tables
• Source 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 on the result set and click Output to File to send the results of this report to Microsoft Excel.