Quickly find out which presenation columns are used in which report

There is no easy way to find out which presentation columns are used in which reports and dashboards. I have come across a situation where we need to quickly identify presentation columns used in each report. I didn’t have enough time to go thru all reports.

To save time, I have created a tool which will output the below information.

Report path and name

Dashboard page name

Presentation column subject area name

All the Filters in the report

All the presentation column names (comma separated)

How to use this tool?

1 Download ReportAnalysisConsoleApplication,

2 Launch cmd

3 In cmd pass parameters as following sequence database SID, Usage track schema user name, password.

Example:

C:\location_of_tool\ReportAnalysisConsoleApplication.exe oracle_database_SID usagetrack_USERID usagetrack_PWD > C:\output_directory_or_what_ever\AnalyzedDataOutput.txt

Prerequisites:

Report should access at least once after usage track enabled.