SAP Analytics Cloud - Dynamic Row level Security

[former_member698641]

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,

[JefB]

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.

[former_member698641]

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]

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.