Data Filter in OBIEE 11g

user8816444

Hi all,

I'd like to set up a multi-dimensional Security Data Filter condition on a Logical Table in OBIEE Repository.

OBIEE version is 11.1.1.7.1.

For example, with the following star schema:

• Dimensions
  • Company
  • Sales Channel
  • ...
• Fact: Sales

and the following security mapping table for user "bob_brown":

OBIEE_User	Company	Sales Channel
bob_brown	Italy S.p.A	Wholesale
bob_brown	Italy S.p.A	Retail
bob_brown	UK ltd.	Retail

I'd like to implement the above mapping using Row-level Security features.

As you can see, It's a filter based on a combination of two dimension attributes.

Is there any (simple) way to get this?

Thanks