View Lineage Information for a Data Item

View lineage information of a data item to see what the item represents before you add it to a report. Lineage information traces the metadata of an item back through the package and the data sources used by the package. Lineage also displays any data item filters that were added by the report author or that were defined in the data model. Viewing lineage information ensures that you add the correct data items to a report. For example, you can view the lineage information of a model calculation to see how it was created.

You can use the lineage tool that comes with IBM® Cognos® Analytics, or you can use another lineage tool by specifying the URL to the tool in IBM Cognos Administration. Note that if the URL source is secured, the source must be able to prompt users for a password because IBM Cognos Analytics does not pass security information. IBM Cognos Analytics also supports the IBM Metadata Workbench as a lineage tool. For more information about configuring other lineage tools, see the IBM Cognos Analytics Administration and Security Guide.

You cannot use lineage information to troubleshoot queries. For example, lineage information will not explain why a data item is double counted. Also, you cannot view lineage information when running a report from a mobile device.

Lineage is not supported in reports that are not linked to packages.

Before you begin

Before you can access lineage information for a report, your administrator must configure lineage in IBM Cognos Administration. Also, the administrator must enable the lineage capability and grant read permission for you on the report. For more information, see the IBM Cognos Analytics Administration and Security Guide.

The IBM Cognos Analytics lineage tool shows lineage on a report at its highest level. The lineage does not change after you drill down on a report. Because the selection context used to launch lineage can be affected by drill-down operations, we recommend that you always launch lineage at the highest report level before drilling down on the report. Otherwise, the lineage may not start properly.

Procedure

  1. Click the Insert Data menu command.
  2. In the left pane, right-click the data item for which you want to see lineage information, and click Lineage.

Results

The lineage tool opens showing the lineage information of the selected data item.