Forum Stats

  • 3,782,437 Users
  • 2,254,645 Discussions
  • 7,880,078 Comments

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 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_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?


Thanks

This discussion has been closed.