Can I use S_NQ_SUMMARY_ADVISOR data without TT or exalytics machine

SPowell42

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

Lamin J

Hi SPowell42!SPowell42

Have you enabled Usage Tracking ? if so have a look at the S_NQ_ACCT tabel.

//Lamin J

SPowell42

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

Syedsalmancs110

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)

Using the Oracle BI Summary Advisor Wizard