Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 283 Oracle Analytics and AI News
- 60 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 108 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
OBIEE Usage Tracking - Physical Tables
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
Answers
-
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.
0 -
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.
0 -
Sorry I meant S_NQ_DB_ACCT
https://docs.oracle.com/middleware/1221/biee/BIESG/usage_track.htm#BABDGJBD
0