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.
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)