cancel
Showing results for 
Search instead for 
Did you mean: 

Is it possible to realize the line data access control in SAP Analytics Cloud?

Dirk666
Discoverer
0 Kudos
150

Hi experts,

Customer wants to control the data visit permissions by the department hierarchy and business roles in SAP Analytics Cloud.

For example:  There're 3 layers of sales manager: HQ sales director > Regional sales manager > Area sales manager. If I create only one story, all the sales managers can visit it, when they open the story, the HQ sales director can see all the regions and areas data, while the regional sales manager can only see his own region data, the area sales manager can only see his own area data.

I don't find any organization structure related config in SAC, it's user permissions are base on "Object", "Team" and "Role", I don't think these 3 factors can realize a line data access control of story. Is that mean I have to create a new story for each regional manager and each area manager?  If so, I have to update the manager permission when the manager changes.

Now I have SAP Datasphere and SAP Analytics Cloud, the Datasphere help document says, I can create permission view according to the department and business role hierarchies, then the different managers can see different data lines when they open the same analytic view.  and the permission view is based on source data sheets, so it will update automatically when the source config changes(e.g. manager role changes in S/4 HANA). Is there similar data access control mechanism in SAP Analytics Cloud?  Furtherly, can the data permission configured in Datasphere be copied to SAC? or the Datasphere permissions can influence the SAC report views by user SSO authentication?  

 

 

Dirk666
Discoverer
0 Kudos
I mean the row-level data access control, each user can only see the records that match the hierarchy values he/she is authorized.
View Entire Topic
William_Yu
Product and Topic Expert
Product and Topic Expert
0 Kudos
Yes, you can achieve that in SAC via Data access control, check this help page for detail: https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/b46f2f74aea04c399ccb5...