Hi there,
I have special requirement on Analysis Service 2019 Tabular model security. Can someone help with idea on how to do or DAX
In SSAS Tabular model has below 2 x tables:
TICKET
PERSON
When person user login to Analysis service tabular model 2019 to browse the data:
CASE WHEN PersonRole= Staff AND SensitiveFlag = 1 THEN Description to replace with NULL
CASE WHEN PersonRole= Head AND SensitiveFlag = 1 THEN Description then show Description column value
CASE WHEN PersonRole= Staff AND SensitiveFlag = 0 THEN Description then show Description column value
CASE WHEN PersonRole= Head AND SensitiveFlag = 0 THEN Description then show Description column value
e.g. When PUID01 login to SSAS tabular model and drag-n-drop Description column then that user must see value from this column regardless of SensitiveFlag value.
e.g. When PUID03 login to SSAS tabular model and drag-n-drop Description column then that user must see value from this column where SensitiveFlag is zero i.e. T899 BUT see NULL value for SensitiveFlag is 1 i.e. T567
Yes Person.PersonUserID is same value as user login id to match.
Any idea please.
Many .Thanks