Skip to Content
Technical Articles
Author's profile photo Daniel Nurindra

SAC Data Restriction/Security with Roles or Data Access Control

This article describes how to deliver data restriction with SAC Security and Acquired Model.  It answers a question like what available methods we can use to restrict data by authorization relevant. 

Table contents: 

  1. Introduction
  2. Restricting data with Data Access Control
  3. Restricting data with Roles
  4. Conclusion

Introduction

Roles or Data Access Control (DAC) can restrict data access. It needs Team as part a setup. I also put the reference if you want to understand further on SAC Security Components such as Roles, Team, User, Folder Security. 

The scenario for this articles is a Headcount Planning and Acquired Model. It has a Country’s inputter/forecaster therefore each inputter restricted by the country relevant. The Acquired Model has a following dimensions:  Employee, cost_center, headcount_account, date, country

Restricting data with Data Access Control

Data access control needs model set up. 

Goto Model -> Model Preferences -> Access and Privacy -> Data Access Control in Dimension -> enable Country for Data Access Control. 

Enable%20Country%20for%20Data%20Access%20Control

Enable Country for Data Access Control

 

Next step is to maintain who can access the Country Data in Country Dimension. 

Goto Model -> Model Structure -> Click Country Dimension (Left Panel: Dimension List)-> it direct to Country DimeBannsion Member list. 

Column Read and Write are available in the dimension. 

Please Maintain Read or Write or both based on the requirement. It can have single/multiple Team, User ID. By maintaining read or write, Data Access is controlled.  

Restricting data with Roles

Data restriction also can be controlled by Roles. Your SAC User ID need to have an access to relevant access for SAC security related such as change roles, user, etc. 

Goto model -> model preference-> enable model privacy (highlighted with yellow) then save the model. 

If it is enabled, you be able to set up the model in the SAC Roles. 

Next, it needs setup Roles.

Goto Menu -> security -> roles -> create new roles  (if you don’t have a role yet) 

Goto Model tab -> select the model  

 

-> maintain Read and write.  

Multiple Dimension can be maintained at read and write. And the beauty is the data access can be set up by dimension property. 

The final step is you need to assign the role into either team or the user ID. 

*** I found if I am a model owner, I still can see all data countries in model. I need to get my colleague to create a model so I can test the security setup. 

Conclusion 

Data Access setup is important as it control the data confidential and it also improve the performance since Users only works with the smaller data where the data is relevant for them.  Personal opinion, the roles looks more centralized setup so security team can own it. 

And yet, you also can do hybrid (both of them) to deliver your requirement. 

How do you setup your Acquired model security? Perhaps, you can add it into the comment. 

Thanks for visiting my blog,

Cheers, 

 

references:

https://wiki.scn.sap.com/wiki/display/BOC/SAP+Analytics+Cloud+-+Security+Concepts+and+Best+Practice

Assigned Tags

      7 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Rajani Aarya
      Rajani Aarya

      This blog definitely has all of the information and facts I needed concerning SAP SCM if you want to learn  SAP SCM Online Training so you can join ShapeMySkills Pvt. Ltd.

      Thanks

      Author's profile photo Daniel Nurindra
      Daniel Nurindra
      Blog Post Author

      Thanks for visiting the blog

      Author's profile photo Veronica P. Alexander
      Veronica P. Alexander

      It's really useful! I read it all and it's really good information. Thanks for this wonderful article!

      Author's profile photo Daniel Nurindra
      Daniel Nurindra
      Blog Post Author

      Your most welcome and thanks for visiting this blog.
      cheers,

      Author's profile photo Viswanathan Ramakrishnan
      Viswanathan Ramakrishnan

      Really good article. I want to use the Data Access control for the first time and want some head up! This blog helped me to start

      Author's profile photo Christian Winheller
      Christian Winheller

      Hi Daniel Nurindra,

      regarding this thought:

      *** I found if I am a model owner, I still can see all data countries in model. I need to get my colleague to create a model so I can test the security setup.

      I suggest you have one or more Demo Users registered to your SAC. These users should be registered on separate demo mail adresses as well, to make sure they aren't connected directly to certain people and be available for all developers or training sessions.

      Author's profile photo Thomas Karner
      Thomas Karner

      Hi Daniel Nurindra, to be honest I´m not happy with both concepts DAC and Roles because both have pros and cons.

       

      DAC

      +) simple configuration

      +) Allows to provide access incl. usage of hierarchies (means I can define access on a certain level and all leaf nodes and leaf members are included)

      -) Using DAC for a dimension is set for all models using this dimension, which means you get dependencies between models which you maybe don´t want.

      -) DAC uses logical AND conditions between the dimensions, which means you can´t define complex conditions

       

      Roles

      +) allow to define complex conditions

      +) support of ISCURRENTUSER allows dynamic configuration

      +) individual definition per model without dependencies

      -) no support of defining conditions on hierarchy nodes, only leaf members are supported which causes efforts to maintain

      -) no support of teams

       

      I´m personally tend always to use roles because I´m less limited, but configuration needs more efforts and there are some limitations (e.g. using hierarchies).

       

      Any other pro´s and con´s you have experienced?

       

      Regards,

      Thomas