Question Re: Data level (Row level) Security in Technology Q&A

Data level (Row level) Security

vijayb — Wed, 16 Jan 2019 09:04:57 GMT

Hi All,

Can we apply data level security in SAP analytics cloud stories.

Thanks,

Vijay

Re: Data level (Row level) Security

amitrathi239 — Wed, 16 Jan 2019 09:22:16 GMT

check attache links.

https://subscription.packtpub.com/book/big_data_and_business_intelligence/9781788290883/10/ch10lvl1sec111/setting-security-for-models

https://blogs.sap.com/2016/04/03/taking-a-look-a-data-security-in-cloud-for-analytics/

https://www.sapanalytics.cloud/resources-roles-and-security-permissions/

Re: Data level (Row level) Security

Kivanc_Oktas — Wed, 16 Jan 2019 09:41:34 GMT

Hi Vilay,

Yes you can. There are several ways:

In the modeller page you can enable data access control in a dimension. After enabling 2 extra column will appear in the model: read and write. There you can define users or groups for each value of the dimension.

You can apply filters during role creation. After defining the permissions for a role there is another tab called models. There you can define filters for the role for specific model and its dimensions.

Last but best you can apply row level security via SSO. So that you can consume the authorization defined in the source system.

Hope this helps.

Best Regards,

Kıvanç

Re: Data level (Row level) Security

vijayb — Thu, 17 Jan 2019 08:34:47 GMT

Thank You Kivanc for your answer.

It's useful when we have less users and less rows in dimension but how about if we have more users and thousands of rows in dimension.

Please let us know is there any other way to apply data security instead assigning it at each row?

Thanks,

Vijay

Re: Data level (Row level) Security

Kivanc_Oktas — Thu, 17 Jan 2019 20:31:02 GMT

You are right if you have thousands Vijay. Instead of defining security to users one by one you can assign them to teams in SAC and assign the roles to the team. That may be easier. It is more or less the same in BW or any other tool.

Re: Data level (Row level) Security

sandip_kumar003 — Tue, 30 May 2023 05:14:03 GMT

Hi,

You can go through this video link:

https://www.youtube.com/watch?v=GyCUF0rdQKw

Best Regards,

Sandip Kumar.

Re: Data level (Row level) Security

sourabhpaul — Wed, 31 May 2023 05:03:10 GMT

Hi,

You cannot apply row level security from the story. you have to apply row level security from model or from the security.

Regards,

Sourabh Paul