cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Analytics Cloud - Dynamic Row level Security

0 Kudos

Can someone please tell me a why to implement row level security in SAP Analytics Cloud.

So depending on the user logged into SAC they should only see particular record for them. I know about Data Access Control but it has to be done manually where I assign each user/team to each row which will not work since we can have >10000 users and they will be increasing over time.

I have also seen the Current user() dynamic text to identify the user but I am not sure how we can pass this back to the model to filter the data.

Input data Source - Flat File,

Accepted Solutions (0)

Answers (1)

Answers (1)

JefB
Active Contributor
0 Kudos

When using Data Access Control, you can assign team instead of individual users

But for row-level security, I suggest you to check out Data Privacy in model settings, then for a given Role select the model and define read/write access rules for any dimension you want.

0 Kudos

Hi Jef,

My main concern is to do it dynamically since we will several thousand users with new users getting added continuously. We don't want to maintain this manually.

For eg: - if there are 100 users currently there will be 100 rows in the model and each user should only be able to access it's 1 row.

1.png

JefB
Active Contributor
0 Kudos

Yeah, so check out the data privacy setting and setup a Role with a rule using "IS CURRENT USER".
This can reference any dimension property where you can maintain a userid.