Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Find all reports where a particular column is used

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
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