The Data Lineage sheet enables you to analyze QVWs in terms of their data sources, how they read data from the sources, and what output files (QVDs) they write to. Before any selections are made, the Lineage Detail section on the sheet displays complete lists of sources, QVW processes, generated QVDs and load statements. It also provides a high-level data source analysis at the top of the page, above the Sources table--the total databases, spreadsheets, QVDs, and the total number of data sources.
When you select a specific QVW, all of its data sources are listed as well as all of the QVDs it generated. When QVW sources are databases, the Load\Select Connections, Sources, and Statements table provides a complete list of SQL statements used to select data from the databases listed in the Sources table.