Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 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