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.
C:\location_of_tool\ReportAnalysisConsoleApplication.exe oracle_database_SID usagetrack_USERID usagetrack_PWD > C:\output_directory_or_what_ever\AnalyzedDataOutput.txt
Report should access at least once after usage track enabled.