cancel
Showing results for 
Search instead for 
Did you mean: 

How to restrict data in universe

Former Member
0 Kudos

Dear Experts,

I am facing the problem on how to restrict data in universe which is connect to SAP BW.

For example :

User A can only view data of company code 1000 on dashboard

User B can only view data of company code 2000 on the same dashboard

User C can view data of all company on the same dashboard

Is the solution to my requirement SSO(Single Sign On)?

I have tried this solution by creating relational connection with SSO but is not successfully done(got error on connection ).

Have anyone got a solution/suggestion?

Best Regards,

Methee P.

Accepted Solutions (1)

Accepted Solutions (1)

former_member207878
Active Participant
0 Kudos

Hi Methee, You can achieve it through row/ object level security. Please refer below for more details:

http://waltonr.wordpress.com/2011/07/04/how-to-apply-row-level-security-within-bo-xi-r3/

Former Member
0 Kudos

Thank you for your information. This way I have to create all the authorization and assign to user group manually. Do you have any other way to do it dynamically. It should retrieve authorization data from BW and get dynamically filtered.

Former Member
0 Kudos

You can try below method

In Universe do self join:

fact_table.company_code in (select table.company.company_code from company_code companycode_alias where companycode_alias.USER_ID= @variable('BOUSER'))

Answers (1)

Answers (1)

former_member195290
Contributor
0 Kudos

Hi Methee,

Check the SCN thread http://scn.sap.com/thread/3191025

Regards,

JC