Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Data Filter in OBIEE 11g

user8816444Jun 10 2014

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

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 8 2014
Added on Jun 10 2014
#11g, #business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #data, #filter, #obiee, #obiee11g, #repository, #security
0 comments
210 views