Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 42 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 277 Oracle Analytics and AI News
- 54 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 19 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Find all reports where a particular column is used
yaseennawaz
Rank 4 - Community Specialist
Hi,
Is there a way in OBIEE to pull all the report where a particular column is being used instead manually opening each and every report and looking for that column.
Regards,
Yaseen
0
Answers
-
Have a look at SampleApp, and the utilities that come with it. One of them scans through your Presentation Catalog and inserts details of every single analysis (including columns used) into a DB table, which is then exposed through the RPD for querying. Works for 11g and 12c.
Online example: http://slc02okq.oracle.com:7780/analytics/saw.dll?Dashboard&PortalPath=%2Fshared%2F10.%20Lifecycle%20and%20Admin%2F_port…
There's Catalog Manager too, which includes a Report function that will also give you the data you want.
0