Using Essbase filters to restrict access in OBIEE dashboards for multiple users

Question

Hi,

Need to use Essbase filters  to restrict access to data in OBIEE Dashboards so that users with no acess to particular members are not able to see any data for  multiple users.

Any suggestions on how to go about it.

Thanks!

cesar.advincula.o · Answer

Hello Sam,

- First, the implementation security and restricted metadata is by "user" and "application roles",

- Second, we need to understand the bi security (  https://docs.oracle.com/cd/E14571_01/bi.1111/e10543/intromartin.htm#CACFIHEB ),

whats about the relationship of Application Roles and Groups.

if you want to implementation the authorization in the metadata, there is ways:

1. Implement a Session Inititialization Block, to get the Application Role of the user, you have to get an database table to get the Roles by user.

2. If your company has a LDAP Server, as a Microsoft Active Directory, Oracle Identity Management, an any others LDAP Server.

You have to implement also the session Initialization Block to get the App roles.

Kind Regards,

Sam999 · Answer

Yeah, I need to replicate the above Metadata through groups. Can we do that ?

cesar.advincula.o · Answer

OK, you could restrict the metadata by "Application Role", you have to go to "Presentation" layer in your RPD, and need to define, Application Role,

This link, could help you, please, follow up

Introduction to Security in Oracle Business Intelligence - 11g Release 1 (11.1.1)

Tell me, if you need more information.

Kind Regards,