My Oracle Support Banner

Performance Best Practice For Implementing Row-Level Security Formulas In Oracle Analytics (Doc ID 3007418.1)

Last updated on FEBRUARY 29, 2024

Applies to:

Oracle Analytics Cloud - Version N/A and later
Oracle Analytics Server - Version 2023 and later
Information in this document applies to any platform.
Oracle Analytics Cloud (OAC)
Oracle Analytics Server (OAS)


This is part of a series of best practice articles for Oracle Analytics. It’s intended for Model Administrators who are using row-level security filters and covers row-level security which has “or logic” and uses empty values when a part of the filter is not applicable. 
Many businesses have security constraints involving different dimensions for different groups of users and for combinations of them.  The simplest implementation will apply filters for all possibilities and use an empty value for dimensions that do not apply to the specific user. 
The correct results are obtained, but the SQL contains extra tables that are not used, which can negatively impact performance.  This post explains how to get Oracle Analytics to dynamically exclude these tables.



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.