DATA access control in SAP analytics cloud for individual member ID

[satheesh04]

Hi All,

I have a requirement to enable DAC in one of my planning model contains 80 k rows of data, each row should have different set of users and a combination with other, in this case could you suggest me how to proceed the security as its very difficult to create ane maintain 80 k teams.

Thanks,
Satheesh.

[N1kh1l]

satheesh04

satheesh04I am not sure 80k rows of data is fact data or master data. If the access is based on master data of dimension try creating DAC at dimension member level

https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/b46f2f74aea04c399ccb5...

Hope it helps

Nikhil

[satheesh04]

Hello Nikhil,

Thanks for replyining. It's master data (Dimension) consist of 80K records. I need to enabele the DAC for each member.

My uses case have lot of combinations. Could you please suggest me with the better approach.

[N1kh1l]

satheesh04

If there are rules spanning across dimensions go for model privacy approach. You can use roles and teams . I am sure you don't mean to say each of the 80k member has a separate access rule. Try to create attributes to group members with similar access.

https://youtu.be/jrd6nO-2b7g

Hope it helps !!

Nikhil