Forum Stats

  • 3,782,317 Users
  • 2,254,637 Discussions
  • 7,880,045 Comments

Discussions

Multidimensional Data Filters in OBIEE

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:

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.

Is there any (simple) way to get this with Init Block and variables?


Thanks

SriniVEERAVALLI

Answers

This discussion has been closed.