Forum Stats

  • 3,782,437 Users
  • 2,254,645 Discussions


Data Filter in OBIEE 11g

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

For example, with the following star schema:

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

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

OBIEE_UserCompanySales Channel
bob_brownItaly S.p.AWholesale
bob_brownItaly S.p.ARetail
bob_brownUK 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?


This discussion has been closed.