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