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 September 2025 update Empower your team with advanced AI insights, enhanced visualizations, deep customization, and seamless collaboration
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Oracle Analytics Cloud and Server

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

1

Views

2

Comments

AbinashBehera

AbinashBehera Rank 5 - Community Champion

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

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