Forum Discussion
Kashinoda
8 years agoAdvocate I
Dynamically Group By / Merge Row
Hi All, I have tried to create a model which implements some basic 'Column' level security. Essentially the columns that require security are placed in a seperate table which has some RLS rul...
Kashinoda
8 years agoAdvocate I
Anonymous
Thanks for your reply, unfortunately a calculated column in the DimProduct table wont work as this will only be populated on process.
Different users will have different access to FactProductConfidential[ProductDescription], this is defined in the 'ConfidentialAccess' table. You can see this yourself by selecting roles 'Everyone' and 'Confidential' and entering 'Other User' as either GHD\mikeshinoda or GHD\janeaustin
Kashinoda
8 years agoAdvocate I
Bump