Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

role level Security | Hide Dimensions

Hello,    Context : Use RLS with 2 groups. Group A can see and use Filter Dimension Table [Client Name]  Group B cant see nor use filter Dimension Table [Client Name]   think of Group A as an ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hello,

     

    I managed to get it working with some duplication ( its not decent but its what the clients wants ) 

     

    Solution:

    1) duplicate table

    2) in the first client dimension ,add a custom column = 1 

    3) in the second client dimension, replace every value with "redacted" except the ID and add a custom column = 0 

    4) merge them together and apply RLS to use either 1 or 0 

aj1973's avatar
aj1973
Icon for Community Champion rankCommunity Champion
5 years ago

Hi Anonymous 

Can I see how you created your Role?

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hello aj1973 

 

I have nothing configured yet.

what i understand is that this isnt actually a RLS matter, it might be Data masking which i even more lost 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hello,

     

    I managed to get it working with some duplication ( its not decent but its what the clients wants ) 

     

    Solution:

    1) duplicate table

    2) in the first client dimension ,add a custom column = 1 

    3) in the second client dimension, replace every value with "redacted" except the ID and add a custom column = 0 

    4) merge them together and apply RLS to use either 1 or 0