Special requirement to mask data for specific users and specific data values

Q&A
, ,
1

hi, I have this special requirement.

datasetA - field1,field2,field3
all users - can see field1,field2,field3
specific user - can see field1,field2
for field3, can see if value not prefixed with ‘XX’. if value prefixed with ‘XX’, only see ‘***’

How to achieve?
Thanks!

2

Hi @lbl,
In regards to the first portion, you can setup CLS to restrict columns/fields from specified users.

However for your second part regarding ‘field 3’, you can’t set limitations or rules on top of your restricted columns. So I would suggest created a calculated field that changes field 3 based on those rules. That way you can then restrict field 3 access to the user but can provide them access to this new calculated field that will follow your desired rules.

3

hi @Brett

I am already using CLS to restrict columns/fields from specified users and RLS to restrict viewing of specified data.

Please explain further on your suggestion to create a calculated field for field 3.

For example, calcfield3 (at dataset level) is masked off when field3 is prefixed with ‘XX’. field3 is restricted from user3 while calcfield3 is exposed to user3 using CLS. At the pivot table visualisation, how to control to show field3 or calcfield3? Is it possible to detect userid in calculated fields / visualisations?

4

Hi @lbl,
Are you bringing your user id through to the analysis layer or is it only setup in your RLS dataset?
Without the user id available, I don’t believe see how you’d be able to incorporate that in your calc. field logic.
In terms of a work around for the visual to show the proper field column; this may be a bit trickier to plan out. Also with the level of complexity, it may be dependent on the rest of the analysis and what’s taking place. To provide additional suggestions, it may be more beneficial if able to upload a copy to the Arena view.