Row-base security : how to filter on a set of value ?
Hello all!
I am currently trying to setup the row-based security in OBIEE and I am facing some difficulties, not sure if they are basic or not:
I'd like my users or groups to access data depending on a list of value.
I know the best practice is to create a session variable and to filter on it in the security filters. But what if I want to filter on n values?
It looks like a session variable can only host one value. Should I then define n variables initialized in my initialization block ? this would limit the number of values I can filter on. I can't believe there isn't a way to make it clean.
More precisely, my context is:
each user can belong to one or more groups
each group is granted access to one or more brands.
So basically, I'd like to filter on "brand in group.brands where group in (all groups in nq_session.groups)"
I don't have any prerequisite on where to store the filter data (repository, database) nor anything else.
Any help much appreciated ! thanks in advance !
Cedric