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. Same as Cognos Report Database Usage by Location except this includes all reports which use a specific package.
Use Case: Verify database columns used by report items in all reports that use a specific package.
Setup: Set the $packageID variable in the script
Category: Cognos Report Info