Using OLS but need to show one column if OLS is true and another if OLS is false

[Bokazoit]

To make sure that GDPR is secure I use OLS and add people to see data if they may see it.

But I would like to create it another way around...

If the person watching the report is not part of those who is allowed to watch GDPR secure reports those columns are switched with another generic column. i.e

Name	Calls
Michael	200
Anna	250

The above column - Name, uses the Name column from the Agent table. If the person is not allowed the Name column will be switched to the NameId colum:

Name	Calls
Name 1	200
Name 2	250

So the users can still see the reports and the numbers, but the names are hidden if they are not allowed.

Any ideas?

[lbendlin]

In your data model carry a copy of the fact table with all PII removed. Offer this table for general reporting.