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
Can I use S_NQ_SUMMARY_ADVISOR data without TT or exalytics machine

Hi, I'm interested in finding out if it's possible to use S_NQ_SUMMARY_ADVISOR table without having (or wanting) times ten or exalytics. Basically, I'd love to be able to query this table just to see what fact tables, logical table sources, and levels were being hit most often, how long average queries ran, # of rows returned, etc. I've enabled writing to that table through usage tracking (in OBIEE 12c), and I can see rows going in there...but everything seems to be coded using "ID" columns. I suspect (but haven't confirmed yet) that these match the underlying UIDs assigned in the RPD. Is there any way to match these up against some sort of database table (in the RCU?) so that I can assign names to the facts, metrics, levels, etc?
Thanks!
Scott
Answers
-
Hi Lamin,
yes, I have usage tracking enabled, and have been gathering statistics for years. But that doesn't give the same information as the summary advisor seems to - I can see both the logical and physical queries, but without trying to parse through all the SQL, there's no way to summarize it by dimension / level. That's what I'm hoping I can use the S_NQ_SUMMARY_ADVISOR table for...but to do so, I need a way to translate it's IDs back into the names of RPD objects.
Thanks!
Scott
0 -
If you are asking that whether Oracle BI Summary Advisor is only possible to be used on Exalytics machine then referring to below mentioned document answer is yes.
How To Enable And Configure Oracle BI Summary Advisor Utility On Exalytics (Doc ID 1472652.1)
0