Issue with Data Access file
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.
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.
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.