Question Re: SAP Analytics Cloud - Dynamic Row level Security in Technology Q&A

SAP Analytics Cloud - Dynamic Row level Security

former_member698641 — Tue, 25 Aug 2020 15:24:21 GMT

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,

Re: SAP Analytics Cloud - Dynamic Row level Security

JefB — Tue, 25 Aug 2020 15:50:27 GMT

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.

Re: SAP Analytics Cloud - Dynamic Row level Security

former_member698641 — Tue, 25 Aug 2020 18:13:42 GMT

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

Re: SAP Analytics Cloud - Dynamic Row level Security

JefB — Tue, 25 Aug 2020 20:19:15 GMT

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.