Locate all the database column dependencies by report item for all report, query and analysis objects for a specific location including descendants. This is based off data lineage information captured by NetVisn. There may be multiple rows for each report item if more than one database column is used in the report or model expressions.
Use Case: Verify database columns used by report items in all reports at a specific Cognos Connection location
Setup: Set the $locationID variable in the script
Category: Cognos Report Info