Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics Cloud November 2025 Update Unlock faster trends, personalized analytics, and efficient data management with the latest OAC AI and admin enhancements.
Introducing the Oracle Analytics & AI Challenge 2026 Showcase your Analytics & AI skills in this Community Challenge!

Oracle Analytics

Categories

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

Can we bring physical query generated by BI Server into S_NQ_ACCT Table for usage tracking.

Received Response

11

Views

2

Comments

AbinashBehera

AbinashBehera Rank 5 - Community Champion

Feb 3, 2017 4:19AM edited Aug 13, 2024 6:07PM in Oracle Analytics

Hi All,

Can we bring physical query generated by BI Server into S_NQ_ACCT Table for usage tracking.?

Is there any way,

Thanks,

Abinash

0

Answers

Gianni Ceresa Mod

Feb 3, 2017 4:44AM

Hi,

No need to do anything as it's already there.

Just look the table next to it: S_NQ_DB_ACCT, there you find the physical query.

0
Gianni Ceresa Mod

Feb 3, 2017 4:45AM

You can look into OBIEE SampleApp (OBIEE Samples ) for some examples on how they used it. Like http://slc02ojt.oracle.com:7780/analytics/saw.dll?Dashboard&PortalPath=%2Fshared%2F10.%20Lifecycle%20and%20Admin%2F_port… (Prodney / Admin123)

0