Can we bring physical query generated by BI Server into S_NQ_ACCT Table for usage tracking.

Question

Hi All,

Can we bring physical query generated by BI Server into S_NQ_ACCT Table for usage tracking.?

Is there any way,

Thanks,

Abinash

Gianni Ceresa · Answer

You can look into OBIEE SampleApp (OBIEE Samples ) for some examples on how they used it. Like http://slc02ojt.oracle.com:7780/analytics/saw.dll?Dashboard&PortalPath=%2Fshared%2F10.%20Lifecycle%20and%20Admin%2F_port…  (Prodney / Admin123)

Gianni Ceresa · Answer

Hi,

No need to do anything as it's already there.

Just look the table next to it: S_NQ_DB_ACCT, there you find the physical query.