How to find the username who modified an OAS analysis

Question

How to find the username who modified an OAS analysis? NQQuery log is the only way? Is there  a SQL or some other way to figure out who modified a report?

Appreciate any help

Thanks

pa

Gianni Ceresa · Answer

Hi,

In Oracle Analytics, the username of who modified a catalog object is stored as one of the various metadata linked to the catalog object.

Up to OBIEE 12c it was an information stored in the .atr file coming with the catalog object.

In OAS it is stored in the database, inside the BIPLATFORM schema, because that's where the catalog has been moved. You can see it through the catalog page, or by doing a webservice call if you want to stay "inside" the product. Or from "outside" the product, by either exporting the catalog (via a BAR snapshot) and work on the catalog offline, or by querying the database.

If you want to use SQL, in your BIPLATFORM schema, in the table named css_si_files you find the modified_by_name, modified_by_type, modified_time columns.

You can search your catalog object by the full_path column, or any other attribute that you find in that table (it's the master table for any catalog object). Do not modify this table, you should have a read-only approach because changing this manually isn't supported by Oracle and you can kill your environment.

NQQuery log isn't really supposed to be giving you the info, because modifying a catalog object doesn't involve executing queries on the BI Server.

Or you maybe mean who last executed/opened the analysis instead of modifying it?