Categories
- All Categories
- Oracle Analytics Learning Hub
- 20 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 233 Oracle Analytics News
- 45 Oracle Analytics Videos
- 15.9K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 87 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations 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