Hi, We are currently using Oracle Analytics Cloud (OAC) with Autonomous Data Warehouse (ADW) and loading data from our on-premises Oracle Database to ADW using Oracle Data Integrator. In Oracle E-Business Suite (R12), we filter data based on operating units by leveraging responsibilities. Could you please guide us on how to implement a similar row-level security (RLS) mechanism in ADW to filter data dynamically based on the logged-in user? Specifically, we would like to understand: How to pass the logged-in user's information from OAC to ADW. Best practices for filtering data at the row level using session variables or other methods in ADW. Thanks, Jay

@Jaykumar Perumal Please refer the below official documentation.

Hi @Jayakumar Perumal How about Building Semantic Models in Oracle Analytics Cloud since you are using OAC Enterprise version now? Thanks Harriet

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

Accepted answer

117

Views

Comments