Analysis Authorization (Role, Profile and Direct Assignments)

[Former Member]

<b>Analysis Authorization Question:</b>

1) In BW 3.x environment, customers have used Role Maintenance Process to assign proper object level security and then assign to the users.

2) Most of the places R/3 security team takes over support/administration function of BI Security and they continue to use Role method to assign “Reporting Authorizations” as per the process defined in BW 3.x system.

3) Customer sometime have 100 + Roles to have 3.X “Reporting Authorizations”. This is Managed, assigned, approved using role concept.

<b>

Migration Options:</b>

1) New Analysis Authorization makes process of Role Maintenance like "hierarchy authorizations" of BW 3.x. You have to create Value in other transactions and assign them in Role as a pointer or link object. With Analysis Authorization concept, Actual value of the Object Assigned “Like Company code 1100” not visible in Role Maintenance PFCG transactions. It is only visible in Transaction code RSECADMIN.

2) Analysis Migration Tool - RSEC_MIGRATION does not update “ROLES”. It creates or changes “PROFILES”.

3) Profiles are assigned to the users and Roles does not reflect any Impact by Analysis Authorization migration.

<b>Questions</b>

a) This means customer need to update all the roles by hand. If they want to use Roles to manage the assignment of the Security to users. Migration Tool does not update Roles, it only updates PROFILES.

b) Does any one use direct assignment to Users? It is good business practice?

c) Is <b>Profiles</b> recommended method of Authorization Maintenance?

d) Can we run migration tool to create Analysis Authorizations, but not assign to the users as a Profile. But stop at creating Analysis Authorizations. If Customer wants to use Roles maintenance process then, they can do not have delete profile assignments from all users before updating Roles using Analysis Authorizations.

Just want to check how other folks have done migration that can be supported going forward.

Pankaj Gupta

[former_member192700 · Accepted solution]

Hi Pankaj,

I have to add a comment to the migration discussion.

The statement that roles are not automatically adjusted, is not correct. Starting with SPS 9 the changes to the respective profiles are also forwarded to the role, thus avoiding manual adjustment of the role after the migration.

Please see OSS note #958665 for details.

Cheers

SAP NetWeaver BI Organisation

[Former Member · Accepted solution]

Hey Andreass, Good to know. Thanks for the info. I hadn't tested this again in SPS9.

Cheers,

Prakash

[Former Member · Accepted solution]

Hello Prakash & Andreass

This works.

My 1st level test shows me that Roles gets updates after the OSS note.

Pankaj Gupta

[Former Member]

Hey Pankaj,

In general, assigning the analysis authorization directly to user makes a lot of sense for granular levels of authorization. For example, if you had 3,000 users, 3,000 specific authorization combinations, and 3,000 roles, using roles is a lot of additional overhead. If you had 12 roles and 3,000 users, your role concept makes a lot of sense.

Therefore, the recommendation is that it varies on what makes the most sense logically. Authorization groups can be created to group analysis authorizations and combine them. Also, you have the ability to generate analysis authorizations using the Content Datastores for this. That is an option as well.

RSEC_MIGRATION does use profiles as you've stated. If you want, there would be manual work to convert to roles afterwards. In case you haven't seen Marc's presentation on security, it's pretty good and covers how to generate authorizations from the datastore.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/media/uuid/ac7d7c27-0a01-0010-d5a9-9cb9d...