OBIEE - Data security (visibility of data)

Bi Server Architecture With Client


This article is about data security or authorization in OBIEE.

Data-level security controls the visibility of data (content rendered in subject areas, dashboards, Oracle BI Answers, and so on) based on the user's association to data in the transactional system.



Row-level security in OBIEE.

Obiee User Group Permission Filter

In this example, if a user of the Country Managers group, select a column of the table SH.Salesfacts or SH.Customers, the logical query will get this filter where the country is equal to the session variable (UserCountry).

SH.Customers.Country =  VALUEOF(NQ_SESSION."UserCountry")

As the session variable (UserCountry) is defined by user, you wil get only the data for the country of the user.

You can also define a column in the name. In this case, you can also set a filter on an other columns if a user choose this column: OBIEE - How to define the BI server security to add automatically a filter when a column is added to an answer (row security level)

(Column|Hierarchy Level)

The hierarchy level security define which level a user as the right to see.

To handle it on a single report, you may use:

WHEN "Dim Organisation"."Business Line" = VALUEOF(NQ_SESSION."MY_BUSINESS_LINE") THEN
  "Dim Organisatie"."Team"
  'All Teams of ' || "Dim Organisatie"."Business Line"
  -- Which correspond to the All or Total Level

Discover More
Saw Object
OBIEE - Dashboard Prompt with data level security

Example of dashboard prompt with a data level security. session variablerow-wise Logical SQL Result : Logical SQL Result :
Obiee Fragmentation Content One Column
OBIEE - Grain - Level of (summarization|aggregation)

Grain definition in the context of OBIEE. The following list describes the different grains in navigating a query: Query grain. The grain of the request. Aggregation grain. The grain of the aggregate...
Obi Edition
OBIEE - Security (Level|Type)

security in Oracle BI can be classified broadly into the following three types. Data-level security Object-level security User-level security see Object-level security controls the visibility...

Share this page:
Follow us:
Task Runner