Categories
- All Categories
- Oracle Analytics Learning Hub
- 30 Oracle Analytics Sharing Center
- 20 Oracle Analytics Lounge
- 243 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16K Oracle Analytics Forums
- 6.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 90 Oracle Analytics Trainings
- 16 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