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