Issue with Data Access file

[Former Member]

Hi All,

I am trying to give write access to 2 different user in two different hierarchy of Account type dimension but when I am assigning individual DAP to particular user, both user are getting write access on both the hierarchy.

Example :

DAP_User1 - should have write access to PL account PL600 (Hierarchy)

DAP_User2 - Should have write access to BS accouts BS000(Hierarchy)

I assigned DAP_User1 to user1 and DAP_User2 to User 2.

But when both the user logged in to BPC excel client, they are able to see both the hierarchy.

Can anyone suggest what am I missing.

Thanks,s

Bharat Vema

[Former Member · Accepted solution]

Hi All,

Issue has been resolved.

I created the dummy user1  & user2 by copying the some other user and that user were having SAP_ALL role assigned to his user id, that's why such type of access conflict was arising.

After removing the SAP_ALL role and setting the proper roles for both the users, DAP is working as designed.

Thanks you all for your help suggestion.

Bharat Verma

[former_member186338]

"DAP_User1 - should have write access to PL account PL600 (Hierarchy)"

...

"But when both the user logged in to BPC excel client, they are able to see both the hierarchy." - what about read access?

Vadim

[Former Member]

Hi Bharat,

Check if user1 and user2 are assigned to any teams, there might be data access profiles assigned to teams which are giving them access to both account hierarchies.

Regards,

Neha

[Former Member]

Hi Neha,

Both the users are assigned to different team and both the team have separate data access profile.

Team:

Users:

User 1:

User 2:

Thanks,

Bharat