Forum Discussion
Solved
RLS managed ‚Deanonymization‘
Hi, I need to have data aggregation on Company Level. I.e., Sales data. Everyone may see the total value and/or other accounts in an anonymized version. I tried a pseudo-anonymized appr...
Hi all,
in the end it was a mix of all - and I am not really at the end yet. So far:
- I created a randomized ID in the main query which changes with each daily refresh. RandomID is the basis of all visuals.
- Names_ is still under RLS and unrelated to main_
- in Main_ I added a measure 'Name' returning the clear name (I.e., Ben) when available in names_, else returning classified
- Example bar chart: use RandomID for category axis. Hide Axis. Use clear name as data label ✅
works well since, RandomID is really hard to track back AND all visuals work fine due to RandomID being a column and not a measure.
Hi all,
in the end it was a mix of all - and I am not really at the end yet. So far:
- I created a randomized ID in the main query which changes with each daily refresh. RandomID is the basis of all visuals.
- Names_ is still under RLS and unrelated to main_
- in Main_ I added a measure 'Name' returning the clear name (I.e., Ben) when available in names_, else returning classified
- Example bar chart: use RandomID for category axis. Hide Axis. Use clear name as data label ✅
works well since, RandomID is really hard to track back AND all visuals work fine due to RandomID being a column and not a measure.