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 New Product Roadmap June 2025 Oracle Analytics June '25 roadmap: OAC & FDI updates, fresh look, enhanced features.
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