Oracle Analytics Cloud and Server

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

Data level security for OBIEE Agents

Received Response
2
Views
1
Comments
User_TJFD0
User_TJFD0 Rank 2 - Community Beginner

Team,

i have one obiee report which contains 10 retail stores data , now i need to design a deliver/agent so that each store owner gets their respective data?

Any leeds?

Thanks

Joji

Answers

  • Agents can run in 2 ways:

    - a single execution of the agent and sent the result to many

    - run as recipients: OBIEE login as every single recipient and send the result only to the recipient itself

    If you have 10 stores and want a single agent to deal with that, you need 10 different recipients which are going to filter the analysis for their own store only when executing as recipient. You generally do that by having some session variable setting values for filters or having row-level security implemented which will display, by default, only the own store data.