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

Scott Paulin

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.

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/26915/is-there-a-way-to-find-all-data-models-using-a-specific-field

Hi @Scott Paulin,

Welcome to the Oracle Analytics Community!

Not sure if it is possible (Assuming you are using Oracle Fusion Application [SaaS]).

But please take a look into the following notes which might be useful for general audit & usage tracking.

https://www.ateam-oracle.com/post/methods-to-extract-audit-monitoring-data-from-fusion-applications

https://blogs.oracle.com/fusionhcmcoe/post/bi-auditing-in-cloud-hcm

Hope this help.

Thank you.

Scott Paulin

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

Gaurav Bharadwaj-Oracle

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

MandeepGupta

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.