OBIEE Usage Tracking - Physical Tables

Question

Hi,

I do an analysis in order to find frequently used reports and their physical tables and columns. I use usage tracking (S_NQ_ACCT) and find which reports are used and how many times, but I do not know which tables (physical) are used for those reports. In order to get tables list, I go catalog manager but this way is not easy (by using create report option) Is there a better option to get all the reports source tables?

Regards,

Dilek

[Deleted User] · Answer

Sorry I meant S_NQ_DB_ACCT

https://docs.oracle.com/middleware/1221/biee/BIESG/usage_track.htm#BABDGJBD

dilek · Answer

Hi,

I mean that catalog manager report shows report based information. Subject area, tables, column etc. However, usage tracking only contains sql and logical sql do not show physical table names.

[Deleted User] · Answer

Not sure what you mean with "In order to get tables list, I go catalog manager"

...but in general S_NQ_ACCT does contain the SQL which means you can get the tables from there.

There is no traversing view which shows queried source objects by analysis.