Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE11g Agent delivery row level security problem

Received Response
11
Views
3
Comments
3782032
3782032 Rank 1 - Community Starter
edited August 2024 in Oracle Analytics Cloud and Server

Hi everyone,

I am using OBIEE 11.1.1.9.0 on windows.

I have to configure Agents to send data to email to a group of users in monthly schedule.

I have 60 users in BI Publisher which are created using realm (defaultAuthenticator).

All this users are following a hierarchy (Region-Branch level of hierarchy) and row security level is applied in repository via BI Administration.

Set1.png

Each user in Obiee has access only to a specific range of data (specific branch). If we login in BI publisher this row security is ok, and works fine.

I have scheduled an agent, to send an dashboard page to this users at the beginning of the month.

Report should be sent to user email, that are configured to My Account of each user.

Set2.png

When agent is scheduled to run with all 60 users in the same time, it succeeds and each user gets an email, but row security is not saved.Users end up receiving data that are not allowed to see.

User of a specific branch does not receive right data. Example user of branch 6 receives report that should be sent to branch 1, but if i login separately with each user and access the same report i get the right data.

Can anyone help me with any idea how to solve this issue?

Thank you,

Elona

Answers

  • SriniVEERAVALLI
    SriniVEERAVALLI Rank 6 - Analytics Lead
    Use Analysis
    Analysis

    Try to use user loginId in the report and use above option in Recipients tab if that works.

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    Your agent is set to execute "as recipient", right? Because otherwise the 60 users receive the content as retrieved by the single user you configured it to run. If you set the agent to run as recipient it will be executed as each one of the 60 users, and there security is supposed to be applied. You can look in the logs to see how the analysis is executed etc.

  • 3782032
    3782032 Rank 1 - Community Starter

    Hi Gianni,

    Agent is configured to run as Recipient

    set3.png

    And in the recipients tab I add the list of users

    set4.png

    It is very difficult to trace the error because the agent ends successfully.

    The issue with row security happens even if there are only two users in the recipient list.

    Thank you for your reply,

    Elona