Can I use S_NQ_SUMMARY_ADVISOR data without TT or exalytics machine — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Can I use S_NQ_SUMMARY_ADVISOR data without TT or exalytics machine

Received Response
1
Views
3
Comments
SPowell42
SPowell42 Rank 5 - Community Champion

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

  • Lamin J
    Lamin J Rank 4 - Community Specialist

    Hi SPowell42!SPowell42

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

    //Lamin J

  • SPowell42
    SPowell42 Rank 5 - Community Champion

    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
    Syedsalmancs110 Rank 6 - Analytics Lead

    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