BusinessObjects Board

Need Row level Security Help

building semantic layer
#1

Hi Friends,

I’m a beginner in implementing the row level security, I need help from all of you in guiding me in implementing the BO Secuirty.

I have a security table in the DWH & we pulled that table in to the Universe . ( Ours is a Snow flake Schema) we have almost 8 facts in the Universe & 6 Contexts.

Please guide me from her and let me know what to do now?
Will be waiting for response.

Thansk,
Anil

sam4u :us: (BOB member since 2008-01-09)

Idea about security
#2

Hi,
If you have a security table, then map a column in the security table with a column in fact table and then write a condition in ‘Manage Access Restrictions’ in the universe.
e.g.if you have security on the country object for each user and if your fact table has a column as country then make a query of it and then use the @variable(‘BOUSER’) to identify the user logged in and then determine the security for the user.

Omkar Paranjpe :us: (BOB member since 2006-02-13)

#3

Hi Omkar,

Thanks for your update. I have 6 fact tables almost do I have to join the security to all the fact tables ?

and how to imply the condition in XI R3.1

Can you please let me know.

Thanks,
Sam…

sam4u :us: (BOB member since 2008-01-09)

#4

Did you read this post, just below :wink:

https://bobj-board.org/t/147386[/quote]

Mak 1 :uk: (BOB member since 2005-01-06)

#5

Hi Mark,

I read that topic but it was a bit confusing for me…

:frowning:

Thanks,
Sam

sam4u :us: (BOB member since 2008-01-09)

#6

Maybe too detailed / too much information!

You join to the facts you wish to restrict…

Mak 1 :uk: (BOB member since 2005-01-06)