Is there a way to find all data models using a specific field?

Question

I asked Oracle this question years ago (and the answer was no), but I wanted to check again with this group to see if anyone found a way to accomplish it.  We need to find all reports in which the National Identifier is being selected in the data model.

MandeepGupta · Answer

https://community.oracle.com/products/oracleanalytics/discussion/comment/70479#Comment_70479

Hi Scott,

Unfortunately, this is not supported and there is no direct way of doing it. We were recently in a similar position, where we had to update position title in all reports with assignment name. We went through all reports one by one only. But while analyzing we built a git repository for future where we have the SQLs stored.

Thanks.

Gaurav Bharadwaj-Oracle · Answer

Hi @Scott Paulin ,

There is no way to do this easily.

I suggest you log an Idea for his here :

https://community.oracle.com/products/oracleanalytics/categories/idealab-otbi

Thanks

Gaurav

Scott Paulin · Answer

Thank you @Bhaskar Konar but these links only talk about the auditing - which is great if you want to know when a report object was changed or run.

I'm looking for out-of-the-box ideas that don't involve copy-paste every data model sql into spreadsheets